Skip to content

Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

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 N16210Simpson Dean H · Limon, COBuilt 1972 · S/N 15073546 N16216Scott Jeffrey A · Camden, TNBuilt 1972 · S/N 15073549 N1621DPease Rex A · Grand Haven, MIBuilt 1951 · S/N 20263 N1621FDimtroff John P · Issaquah, WABuilt 1966 · S/N 17255016 N1621HDavis Vance · Del Valle, TXS/N 177RG0794 N1622Susanville Aviation LLC · Susanville, CAS/N 18268181 N16221Aero Maintenance Inc · Vancouver, WABuilt 1972 · S/N 15073553 N16222Thumser Douglas Francis · Newcastle, CABuilt 1972 · S/N 15073554 N16223Flyhnz LLC · Oxford, NCS/N 15073555 N16225Tumminaro Michael · Neodesha, KSBuilt 1972 · S/N 15073557 N1622CPutnal Aviation LLC · Ambrose, GABuilt 1953 · S/N 30322 N1622FN1622f LLC · Grand Prairie, TXBuilt 1966 · S/N 17255017 N1622HSweeney Kay M · Kirkland, WABuilt 1975 · S/N 177RG0795 N1622QSchweim Robert J · Ocean City, NJBuilt 1971 · S/N 15072922 N16238Hayes Lance Garett · Opelousas, LABuilt 1972 · S/N 15073564 N1623CCarlson Thomas G · Anchorage, AKS/N 30323

Back to AD 87-20-03 R2