Skip to content

Registered aircraft · 40,471

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N787ATCentral Virginia Flyers Flying Club Inc · Glen Allen, VABuilt 1976 · S/N 17267881 N787BRNaron Robert W · Poolville, TXBuilt 1965 · S/N 28-2091 N787CPArnett Wallace · Sullivan, INBuilt 1968 · S/N 17257760 N787DJDgj Tex LLC DBA · Cleburne, TXBuilt 1977 · S/N 28-7816014 N787EBStith Michael P · Boiling Springs, SCS/N AA5-0819 N787MTHeppe Andrew S DBA · Turner, MTFirst renewal noticeBuilt 1966 · S/N 18-8425 N787RPSilver Fox Aircraft LLC · Queen Creek, AZBuilt 1985 · S/N 28-8690025 N787STCitabria N787st LLC · Reno, NVS/N 486-2004 N787TKennedy Thomas M · Long Beach, CABuilt 2015 · S/N 0248 N787WTSemper Supra Air LLC · Ashland City, TNBuilt 1978 · S/N 17271319 N78804Whitt James M · Meadowview, VABuilt 1968 · S/N 17257772 N78805Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 17257773 N78808Ginter Michael J · Oakland, MDBuilt 1968 · S/N 17257774 N7880GGhegan John · Wilmer, ALBuilt 1970 · S/N 17259580 N7880WSefinas Avir LLC · Brooklyn, NYBuilt 1964 · S/N 28-1904 N7881GSmith John T · Greenfield, INBuilt 1970 · S/N 17259581 N7881WEast Crest Management LLC · Eastvale, CABuilt 1964 · S/N 28-1905 N7882CKeck Joseph S · Las Vegas, NVS/N 28-7625087 N7882VSlepian Isaac J · El Dorado Hills, CABuilt 1965 · S/N 2844 N78830Frederick Wayne Schultz · Bradley, ILBuilt 1968 · S/N 17257782 N78834Barron Ted L · Hoover, ALBuilt 1968 · S/N 17257783 N7883DMeierotto Marty · Two Rivers, AKBuilt 1957 · S/N 18-6043 N7883VFranks Gary E · Ponder, TXBuilt 1964 · S/N 2845 N7883WStack Brian James · Paso Robles, CABuilt 1964 · S/N 28-1907 N78842Helice Sarcelle LLC · San Antonio, TXBuilt 1968 · S/N 17257787 N78846Aero Investors Lc · Jackson, MIS/N 17257788 N78850Karpik Richard Paul · Grand Rapids, MNBuilt 1968 · S/N 17257790 N78856Bedwell Christopher A · Paso Robles, CABuilt 1968 · S/N 17257791 N78857Hunt Thornton Trevon · Aurora, COBuilt 1968 · S/N 17257792 N7885DLindstrom Daniel G · Somerset, WIBuilt 1957 · S/N 18-6045 N7885WCp Authority LLC · Poulsbo, WABuilt 1964 · S/N 28-1909 N78861Wood Jeffrey A · Willis, TXS/N 253 N78865Gingras Carl A · Avondale, COS/N 2880 N78869Zullo Thomas L · Lindenhurst, NYBuilt 1964 · S/N 2884 N7886GArctic Barnabas Ministries Inc · Kenai, AKBuilt 1970 · S/N 17259586 N7886VLowenhaupt Michael J · Metairie, LABuilt 1964 · S/N 2848 N7886WChelena Eric D · San Antonio, TXBuilt 1964 · S/N 28-1910 N78871Rosenfeld Kristina M · Eureka, CABuilt 1964 · S/N 2886 N78873Mesner Steven M · Tomah, WIBuilt 1964 · S/N 2888 N78875Janssen Christopher R · Ankeny, IABuilt 1964 · S/N 2890 N78877Obrien Garrett G · Sheep Ranch, CABuilt 1965 · S/N 254 N7887GLandrum Erik · Austin, TXBuilt 1970 · S/N 17259587 N7887WDepp Gregory B · Ft Worth, TXBuilt 1964 · S/N 28-1911 N78880Coma Aviation LLC · Buckhannon, WVBuilt 1964 · S/N 2895 N78882Triplat Bonnie E · Rosamond, CABuilt 1964 · S/N 2897 N78884Cooke Daniel S · Kanarraville, UTBuilt 1964 · S/N 2899 N78888Woodard Ben C · Truckee, CABuilt 1964 · S/N 2903 N7888MMonpas Mark E · Anderson, CABuilt 2011 · S/N 72599 N7888WLashinski Michael J · Monument, COBuilt 1964 · S/N 28-1912 N7888YBurkel Robert G · Hemet, CABuilt 1966 · S/N 30-975

Back to AD 80-04-03 R2