Registered aircraft · 16,280

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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N789FBHot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 28020211 N789JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020089 N789JNChandelle Co · Marion, IABuilt 1989 · S/N 4622056 N789NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881307 N789PWTango Whisky LLC · Thomaston, GAFirst renewal noticeBuilt 2007 · S/N 2341 N789RHHambric Bryan · San Angelo, TXBuilt 2002 · S/N 1241 N789SPReed David Allen Trustee · Pinedale, WYBuilt 2003 · S/N 0742 N789SVPaulukaitis Robert Adam · Hudson Oaks, TXBuilt 2023 · S/N 2881632 N789VBFsq Aviation LLC · Dover, DEBuilt 2004 · S/N 0806 N789VVReeder Paul A · Weston, MABuilt 2005 · S/N 40.532 N78BGKdrd Holdings LLC · Texas City, TXBuilt 1977 · S/N 28-7890100 N78CDPolyresources · Naperville, ILBuilt 2003 · S/N 0456 N78EEEagle Property Group LLC · Virginia Beach, VABuilt 2002 · S/N 0325 N78EMMcclure Holding LLC · Alvaton, KYBuilt 2014 · S/N 4105 N78FLFlight Levels LLC · Ridgeland, MSBuilt 2005 · S/N 4636371 N78GLB & L Grumman Tiger LLC · Pennsburg, PABuilt 2007 · S/N 2333 N78JEDodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 411030 N78JMDye William M · Atlanta, GABuilt 1976 · S/N 28-7690430 N78LBBernston Lowell · Kulm, NDBuilt 2022 · S/N 8799 N78LPStreamlineaero LLC · Omaha, NEBuilt 2007 · S/N 3257459 N78MFMartin Flight LLC · Menomonee Falls, WIBuilt 2025 · S/N 10760 N78MGCirrus Design Corp · Knoxville, TNBuilt 2020 · S/N 4907 N78MMCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11560 N78PZMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2024 · S/N 9916 N78RCAviaries LLC · Sun Prairie, WIBuilt 2002 · S/N 1259 N78RDPrecision Wingman LLC · Kingston, OKBuilt 2008 · S/N 3043 N78SZAdhika Aviation Corp Trustee · Wilmington, DEBuilt 2016 · S/N 4301 N78TACti Aircraft Leasing LLC · Memphis, TNBuilt 2020 · S/N 2881295 N78TDAirflair Inc · Maurice, IABuilt 2017 · S/N 2345 N78TMBowlin Ronald R · Camarillo, CABuilt 1977 · S/N 28-7890216 N78USUtah State University · Logan, UTBuilt 2020 · S/N 40.1219 N7900CSdd Aviation LLC · Thomasville, GABuilt 1975 · S/N 28-7690087 N7901CFrost Aviation Alliance LLC · North Hollywood, CABuilt 1975 · S/N 28-7690088 N790AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2026 · S/N 4496641 N790BHSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 2964 N790FBEagle Aviation LLC · Fishers, INBuilt 2025 · S/N 28020212 N790GKAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1979 · S/N 44-7995316 N790NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2017 · S/N 4496405 N790UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020169 N791CDBartlett Aviation Group LLC · Midland, TXBuilt 2004 · S/N 1424 N791CRPryll Gary · Cape Coral, FLBuilt 1980 · S/N 28-8090259 N791EBSav Aviation LLC · Jacksonville, TXBuilt 1980 · S/N BB791 N791KDKrupa Rafal · Hampstead, NCBuilt 2004 · S/N 1143 N791LHFancy Dog Aero LLC · East Wakefield, NHBuilt 2005 · S/N 1739 N791NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2017 · S/N 4496406 N791PGCirrus Design Corp · Duluth, MNS/N 11755 N791PSTake Flight Aviation LLC · Montgomery, NYBuilt 2007 · S/N 40.791 N7927SFarag Abdelrahman · Milwaukee, WIBuilt 2001 · S/N 1162 N792AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843795 N792CDLewis Richard B · Hattiesburg, MSBuilt 2006 · S/N 1618

Back to AD 2008-06-28 R1