Registered aircraft · 56,578

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1781TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12112 N1781VAmbis Edward J · Ithaca, NYBuilt 1976 · S/N R1722212 N1782DRegistration Pending · Homer, AKRegistration pendingS/N 20350 N1782FCfi Care Inc · Woodbury, CTS/N 17255177 N1782TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12113 N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744 N1783MRyan Jason P · San Francisco, CABuilt 1975 · S/N 18264443 N1784FTompkins Wyatt · Pearland, TXBuilt 1966 · S/N 17255179 N1784MWhitledge Aviation LLC · Princeton, INBuilt 1975 · S/N 18264444 N1784QRed Cardinal Aviation LLC · Chantilly, VAS/N 15073084 N1785CBorns Frederick G · Chandler, AZBuilt 1953 · S/N 30485 N1785FSale Reported · Farragut, TNSale reportedBuilt 1966 · S/N 17255180 N1786MClark David A · San Jacinto, CABuilt 1971 · S/N 33701386 N1786XS K Cattle Co · Manhattan, KSBuilt 1975 · S/N 21060806 N1787CMorris Charles W · Wasilla, AKBuilt 1953 · S/N 30487 N1787DKissel Patrick J · Anchorage, AKBuilt 1951 · S/N 20230 N1787FSchroder Robert D · Buckeye, AZBuilt 1966 · S/N 17255182 N1787QHancock Aviation LLC · Baton Rouge, LABuilt 1971 · S/N 15073087 N1788QElgamil Noureldin M · West New York, NJBuilt 1971 · S/N 15073088 N1788TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12114 N1789Hill Sheldon S · Minot, NDFirst renewal noticeBuilt 1974 · S/N 18502342 N1789CBuxton Tracy S · Enterprise, UTBuilt 1953 · S/N 30489 N178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2003 · S/N 17281177 N178CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13039 N178DRH&H Trucking Inc · Clarkdale, AZBuilt 1970 · S/N 17701575 N178EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N P3370285 N178FVD R Tripp Enterprises LLC · Omaha, NEBuilt 1976 · S/N 17267284 N178GWBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12491 N178KASwartzentruber Robert · Oakland, MDBuilt 1971 · S/N 17260069 N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445 N178RSDowns Austin J DBA · Liberal, KSBuilt 1974 · S/N 17262925 N178SKOppenheim Kyle A · Mountain View, CABuilt 1978 · S/N 177RG1320 N178VVStanley Bryan Dale · Paso Robles, CABuilt 1967 · S/N 185-1232 N178ZLUsda Forest Service Fepp · Columbia, SCBuilt 1963 · S/N 18254850 N1790FTaylor Henry F · Urbana, OHBuilt 1966 · S/N 17255185 N1790RBlack Dog Holding Inc · Pleasant Valley, NYS/N 18502506 N1791MA & S Helicopters Inc · Cahokia, ILBuilt 1971 · S/N 33701391 N1791QNearpass Stephen J · Seneca Falls, NYS/N 15073091 N1791VOmargows Ali · Columbus, OHBuilt 1974 · S/N 17263752 N1792REcho Matrix LLC · Bentonville, ARBuilt 1974 · S/N 18502508 N1793DThompson Joshua L · Delta Junction, AKBuilt 1951 · S/N 20235 N1793QFreedom Aviation Inc · Lynchburg, VABuilt 1971 · S/N 15073093 N1793VAviation Capital Management LLC · San Jose, CABuilt 1974 · S/N 17263753 N1794CAcp Aviation LLC · Oakdale, LABuilt 1953 · S/N 30494 N1794MSkyriders Flying Club Inc · Aurora, COBuilt 1975 · S/N 18264447 N1794XGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 21060814 N1795CSchellhaas Bennett · Galloway, OHBuilt 1953 · S/N 30495 N1795RBroussard Kenneth John · Lafayette, LABuilt 1974 · S/N 18502511 N1796DRacoon Aviation LLC · San Antonio, TXBuilt 1951 · S/N 20238 N1797CKelley Larry D · Portland, ORBuilt 1953 · S/N 30497

Back to AD 79-10-14 R1