Registered aircraft · 16,284

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.

N924EBEagle Enterprise Group LLC · Houston, TXBuilt 2006 · S/N 41708 N924JTNelsonsota LLC · Edina, MNBuilt 2022 · S/N 8905 N924NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881886 N924TM & B Aviation LLC · Wake Forest, NCBuilt 2010 · S/N 4636466 N924TKKwality Aviation LLC · Mamaroneck, NYBuilt 2025 · S/N 10701 N924TRR & R Assets LLC · Temple Terrace, FLBuilt 2021 · S/N 2708 N924WOcean Isle Aviation LLC · Ocean Isle Beach, NCBuilt 2001 · S/N 0048 N92500Romeo Charlie Aviation LLC · Stuart, FLBuilt 1994 · S/N 2890207 N92505Thunderbird Aviation Inc · Bloomington, MNBuilt 1994 · S/N 2890211 N9250CRegion Flyers LLC · Valparaiso, INBuilt 1978 · S/N 28-7816451 N9251EArrowpoint Investments LLC · Mountain Brk, ALBuilt 1994 · S/N 3213084 N92521G&J Myles Aviation LLC · Owens Cross Roads, ALBuilt 1995 · S/N 4622191 N9253CJetstream LLC · River Forest, ILBuilt 1995 · S/N 4622183 N9253MBlue Eagle Air LLC · Singer Island, FLBuilt 1985 · S/N 32R-8513010 N9253NJjd LLC · Middleton, WIS/N 32R-8013065 N9254KBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7690237 N9255Moll Andrew Regan · Bentonville, ARBuilt 2006 · S/N 1651 N9255BAero Partners LLC · Sioux Falls, SDBuilt 1995 · S/N 4622197 N9255CD&J Aviation LLC · Apopka, FLBuilt 1978 · S/N 28-7890393 N9256CBluegrass Aviation LLC · Clarksville, TNBuilt 1978 · S/N 28-7890394 N9256DGonitzke Ross J · Detroit Lakes, MNBuilt 1995 · S/N 2890227 N9256XBird Acquisition LLC DBA · Phoenix, AZBuilt 1995 · S/N 4496002 N9257CAcorn Aviation LLC · Saint Charles, ILBuilt 1978 · S/N 28-7890395 N9257NJohn Bowman Inc · Fountain, COBuilt 1995 · S/N 4636006 N9258CBack Forty Flying Club Inc · Roanoke, INBuilt 1995 · S/N 2843002 N9258DFlansburg Robert D · Middletown, DEBuilt 1995 · S/N 3246007 N9258NKma Aircraft Dream LLC · Osteen, FLBuilt 1995 · S/N 28-43014 N9259RAndiamo Aviation LLC · Stonecrest, GABuilt 1995 · S/N 32-46010 N925CCN925cc Inc Trustee · Wilmington, DEBuilt 2008 · S/N 2992 N925CGTabor Holdings LLC · Wolcott, COS/N 3645 N925DSStarlight Technology Transfer Inc · Leesburg, VABuilt 2002 · S/N 40.225 N925GWAzure Aviation LLC · Wadsworth, OHBuilt 2024 · S/N 9927 N925KDBenson Thomas W Trustee · Weston, MABuilt 2005 · S/N 1673 N925LBPanasuk Gary A · Lyons Falls, NYBuilt 2019 · S/N 4835 N925LCBlue Angel LLC · Northville, MIBuilt 2020 · S/N 4985 N925MSBargfrede Bernard Trustee · Blackburn, MOBuilt 2002 · S/N 0342 N925PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843288 N925PCLee Investment Services LLC · Madisonville, TXBuilt 2005 · S/N 1633 N925PDC2 Aviation LLC · De Soto, KSBuilt 2005 · S/N 1270 N925PWN37gd LLC · Fort Myers, FLBuilt 2001 · S/N 0122 N925RHVan Belle Christopher J · San Diego, CABuilt 2002 · S/N 40.212 N925SBCirrus Design Corp · Duluth, MNS/N 11783 N925SEValiair Lc Trustee · Casper, WYBuilt 2006 · S/N 2232 N925SRMiller Mason · Fort Myers, FLBuilt 2007 · S/N 1846 N925TCJarvis Bradley A · North Port, FLBuilt 1981 · S/N 32R-8129013 N925YHPlane Fun Inc Tr Trustee · Snellville, GABuilt 2008 · S/N 40.925 N9260PRichter Scott J · Eden Prairie, MNBuilt 1996 · S/N 4636044 N9260TCanoace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8616033 N92610Adventure Flight Aviation Inc · Springdale, ARBuilt 1995 · S/N 3246014 N9262GChampion Med LLC · Dover, DEBuilt 1995 · S/N 4636017

Back to AD 2008-06-28 R1