Skip to content

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.

N1613MMclaughlin Drew V · Anchorage, AKBuilt 1970 · S/N 18501833 N1613VMcewen Michael A M D · Gadsden, ALBuilt 1974 · S/N 17263692 N1613YNelson Bobby E · Lago Vista, TXS/N 17249313 N1614CMaggie L Air Service LLC · Kalispell, MTS/N 30314 N1614FMathena Chad R · Narrows, VABuilt 1966 · S/N 17255009 N1615AAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9910 N1615EFisher Ralph B · Lutz, FLBuilt 1978 · S/N 17271067 N1615FWells Edmund B · Austin, MNBuilt 1966 · S/N 17255010 N1615VFrance Jeffrey A · Reedville, VABuilt 1974 · S/N 17263693 N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651 N16165Registered aircraftBuilt 1972 · S/N 15073514 N16166Hayden Scott M · Walworth, WIBuilt 1972 · S/N 15073515 N16169Trotter Patrick J · North Las Vegas, NVBuilt 1972 · S/N 15073518 N1616CCleared Direct LLC · Seville, OHBuilt 1953 · S/N 30316 N1616DCorbin Sarah R · Anchorage, AKFirst renewal noticeBuilt 1951 · S/N 20258 N1616FMarciel John L · John Day, ORBuilt 1966 · S/N 17255011 N1616HMayworm Jeffrey A · Ocala, FLBuilt 1975 · S/N 177RG0789 N1616QKrehbiel Bradley C · Lake City, MNS/N 15072916 N16174Cirrostrats Inc · Deland, FLBuilt 1972 · S/N 15073523 N16177Norby Aviation LLC · Hopkinton, MABuilt 1972 · S/N 15073525 N16179Farrell Donald A · Owasso, OKBuilt 1972 · S/N 15073527 N1617CRetroair Restoration LLC · Big Lake, AKBuilt 1953 · S/N 30317 N1617HFlying Cloud Cherokees Inc · Chanhassen, MNBuilt 1975 · S/N 177RG0790 N1617QAljanabi Mohammed Khalid · Herndon, VAS/N 15072917 N1617VCook Timothy D · Ashville, NYBuilt 1974 · S/N 17263694 N16180Last Mango Air LLC · Fond Du Lac, WIBuilt 1972 · S/N 15073528 N16184Finkel David M · Shelbyville, INS/N 15073530 N16185Schwartz David W · Windsor, NYBuilt 1976 · S/N 17702491 N1618DJutting Anthony C · Fruitland, IDS/N 20260 N1618FCastillo Giovanny G · Brodheadsville, PAS/N 17255013 N1618HMemrick Paul · Cedar Park, TXBuilt 1975 · S/N 177RG0791 N1618MFluckey Gary T · Homer, AKBuilt 1970 · S/N 18501834 N16194Booth Jesse R · Alamosa, COBuilt 1972 · S/N 15073537 N16196Macdonald Kaitlyn A · Dillon, MTBuilt 1972 · S/N 15073539 N16199Allbritton John Mark Trustee · Oakland, TNBuilt 1976 · S/N 17702493 N1619DVintage Pacific Aviator LLC · Redondo Beach, CABuilt 1951 · S/N 20261 N1619FReeve Howard E · Minot, NDS/N 17255014 N1619QAmos Carl R · Chandler, INBuilt 1971 · S/N 15072919 N161APT3 Aerosports LLC · Vian, OKFirst renewal noticeBuilt 1964 · S/N 17251383 N161CTEddy Company Inc · Apple Valley, CABuilt 1984 · S/N 18268414 N161EWalsh David E · North Platte, NEBuilt 1956 · S/N 32692 N161GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1986 · S/N 17276650 N161KWKirtland Aero Club · Albuquerque, NMBuilt 1976 · S/N R1722002 N161VPConservation Aviation LLC · Washington, DCBuilt 1971 · S/N U20601719 N16202Steward Charles M · Tuttle, OKS/N 15073543 N16206Schultz Aviation Services LLC · Crowley, LABuilt 1972 · S/N 15073544 N16207Martinez Jose Antonio · Orlando, FLBuilt 1972 · S/N 15073545 N1621Diem Ronald · Myerstown, PABuilt 2025 · S/N 18283315 N16210Simpson Dean H · Limon, COBuilt 1972 · S/N 15073546 N16216Scott Jeffrey A · Camden, TNBuilt 1972 · S/N 15073549

Back to AD 79-10-14 R1