cfr_sections

Current Code of Federal Regulations (eCFR) — the actual text of federal regulations in force. Covers 19 CFR titles with 123,000+ regulatory sections and full-text search.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

2 rows where part_number = 214 and title_number = 14 sorted by section_id

✎ View and edit SQL

This data as json, CSV (advanced)

title_number 1

part_number 1

agency 1

section_id ▼ title_number title_name chapter subchapter part_number part_name subpart subpart_name section_number section_heading agency authority source_citation amendment_citations full_text
14:14:4.0.1.1.10.0.1.1 14 Aeronautics and Space II A 214 PART 214—TERMS, CONDITIONS, AND LIMITATIONS OF FOREIGN AIR CARRIER PERMITS AUTHORIZING CHARTER TRANSPORTATION ONLY       § 214.1 Applicability. FAA     [ER-1223, 46 FR 28379, May 26, 1981] This part establishes the terms, conditions, and limitations applicable to charter foreign air transportation pursuant to foreign air carrier permits authorizing the holder to engage in charter transportation only.
14:14:4.0.1.1.10.0.1.2 14 Aeronautics and Space II A 214 PART 214—TERMS, CONDITIONS, AND LIMITATIONS OF FOREIGN AIR CARRIER PERMITS AUTHORIZING CHARTER TRANSPORTATION ONLY       § 214.2 Terms of service. FAA     [ER-1223, 46 FR 28379, May 26, 1981] Charter air transportation under this part shall be performed in accordance with the provisions of part 212 of this chapter.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE cfr_sections (
    section_id TEXT PRIMARY KEY,
    title_number INTEGER,
    title_name TEXT,
    chapter TEXT,
    subchapter TEXT,
    part_number TEXT,
    part_name TEXT,
    subpart TEXT,
    subpart_name TEXT,
    section_number TEXT,
    section_heading TEXT,
    agency TEXT,
    authority TEXT,
    source_citation TEXT,
    amendment_citations TEXT,
    full_text TEXT
);
CREATE INDEX idx_cfr_title ON cfr_sections(title_number);
CREATE INDEX idx_cfr_part ON cfr_sections(part_number);
CREATE INDEX idx_cfr_agency ON cfr_sections(agency);