Registered aircraft · 16,295

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.

N16WDFront Run Investors LLC · Commerce, GABuilt 2017 · S/N 4552 N1702HHesston College · Hesston, KSBuilt 1977 · S/N 28-7790336 N1707SUtah State University · Logan, UTBuilt 2005 · S/N 40.509 N170CDStrategic Leasing Investments And Consulting LLC · Madison, WIBuilt 2000 · S/N 1076 N170DLRlw 767 LLC · Lighthouse Point, FLBuilt 2006 · S/N 2017 N170DSSmith Mountain Lake Flying Club LLC · Hardy, VABuilt 2005 · S/N 40.465 N170EJZirkel Acquisition Corp LLC · Colchester, VTBuilt 2010 · S/N 3604 N170HSAero Leasing LLC · Brandon, MSBuilt 1982 · S/N 34-8233164 N170LAEducators Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4697341 N170LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881376 N170MAEarle George W · Spring, TXBuilt 2003 · S/N 40.272 N170PGCmt Aviation LLC · Corsicana, TXBuilt 2008 · S/N 1961 N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28 N170SGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2014 · S/N 4122 N170SRSj Airways LLC · Wilmington, DEBuilt 2007 · S/N 2456 N17113J&L Aviation LLC · Lakewood Ranch, FLBuilt 2012 · S/N 3851 N171CAAircraft Parts Store LLC · Jacksonville, FLBuilt 2002 · S/N 4496131 N171CBBennett Christopher D Trustee · Cupertino, CABuilt 2008 · S/N 40.969 N171CDBartlett John M · Everett, WABuilt 2000 · S/N 1080 N171EPAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841209 N171HPAlliance Diversified Enterprises Inc · Escondido, CABuilt 2008 · S/N 4697371 N171HTChico Gregory John · Dayton, NVBuilt 2005 · S/N 1613 N171JBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1968 · S/N 28R-30756 N171MElevated Holdings Inc · Newport Beach, CABuilt 2024 · S/N 4636841 N171MAChute First LLC · Covina, CABuilt 2005 · S/N 1398 N171PPiper Aircraft Inc · Vero Beach, FLS/N 28020291 N171PSDiamond Air LLC · Salem, VABuilt 2006 · S/N 40.701 N171SFStratusfire LLC · St Charles, ILBuilt 2005 · S/N 40.494 N171SRRegistered aircraftS/N 2422 N171TDFh Consulting LLC · Christiana, TNBuilt 2020 · S/N 4973 N171TSWindow Universe LLC · Beaverton, ORBuilt 2008 · S/N 2900 N171TTMindensky LLC · Stateline, NVBuilt 2026 · S/N 11251 N171TWRsj Aviation LLC · Winston Salem, NCBuilt 1984 · S/N 32R-8413019 N171VTShly Aviation LLC · Carnegie, PABuilt 2002 · S/N 0142 N1724XN2200b LLC · Cicero, NYBuilt 2014 · S/N 4090 N1728HTn Millworks LLC · Mt Juliet, TNS/N 28-7716047 N172MAN172ma LLC · Miramar Beach, FLBuilt 2006 · S/N 4697263 N172MZ720 Aviation LLC · Spokane Valley, WABuilt 2006 · S/N 40.730 N17324Macair Aviation LLC · Xenia, OHBuilt 1979 · S/N 287916050 N1734HIndian Hills Community College · Ottumwa, IABuilt 1977 · S/N 28-7716048 N173CBAircraft Associates LLC · Valparaiso, INBuilt 2006 · S/N 1877 N173CDVe Transportation Inc · San Diego, CABuilt 2000 · S/N 1051 N173JPRochin Eric M · Malibu, CABuilt 2005 · S/N 40.486 N173KHD & B Management LLC · Clayton, GABuilt 2004 · S/N 1191 N173MMitchell Jonathan L · Poteau, OKBuilt 1981 · S/N 32R-8113087 N173MAStellar Aviation LLC · Benton, KYBuilt 2003 · S/N 40.292 N173RSShining Ventures LLC · Houston, TXBuilt 2003 · S/N 40.336 N173SRRomeo Pappa LLC · Midlothian, TXBuilt 2006 · S/N 1925 N173WMBoard Of Trustees Of Western Michigan University · Battle Creek, MIS/N 1739 N1743HN1743h LLC · Yorktown, VAS/N 28-7790337

Back to AD 2008-06-28 R1