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.

N19SKEagle Capital Holdings LLC · Doylestown, PABuilt 2025 · S/N 10862 N19SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 2364 N19TRCoda Aviation LLC · Athens, TXBuilt 2018 · S/N 4601 N19VGLv4 Aviation LLC · Sheridan, WYBuilt 2009 · S/N 4692108 N19WERlv Industries Inc · Westerly, RIBuilt 1997 · S/N 3449037 N1AYRoyal Aviation LLC · Hendersonville, TNBuilt 2021 · S/N 5031 N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361 N1RQEnthios Enterprises LLC · Columbus, INS/N 4697112 N1SJRegistered aircraftBuilt 2017 · S/N 4493 N1UCBas Part Sales LLC · Greeley, COS/N LW-140 N1UKPenn Flight School LLC · Quakertown, PABuilt 1977 · S/N 28-7790564 N1WLGray William Loyd Jr · Nashville, TNBuilt 2002 · S/N 4636337 N2000M2000m LLC · Savannah, GAS/N 1475 N2003MRoyal Timothy G · Apex, NCBuilt 1977 · S/N 28-7890221 N200ADNouvel Avion LLC · Miami Gardens, FLBuilt 1976 · S/N 28-7690230 N200ARHelijet Holdings LLC · Wellington, FLBuilt 2004 · S/N 1122 N200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293 N200DRRowe Daniel · Alexandria, VABuilt 2019 · S/N 4860 N200EUSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1517 N200FKJmm Air LLC · Put In Bay, OHBuilt 2007 · S/N 3232072 N200GRLpc Aviation Inc · Punta Gorda, FLS/N 1300 N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568 N200HCIncredible Travels LLC · Celina, OHBuilt 2008 · S/N 3286 N200JEBloch Gregory S · Xenia, OHBuilt 2011 · S/N 4636501 N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40 N200JPBlacklist LLC · Lake Norden, SDBuilt 2014 · S/N 4636649 N200LBBresciani Martin · Guaynabo, PRBuilt 2002 · S/N 0209 N200PKGo Green Aviation LLC · Hillburn, NYBuilt 2026 · S/N 11260 N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410 N200RELw164 Inc Trustee · Wilmington, DEBuilt 1975 · S/N LW-164 N200RMMps Enterprises LLC · North Platte, NEBuilt 1973 · S/N LW-45 N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273 N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246 N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680 N202CMCambridge LLC · New Cumberland, PABuilt 2005 · S/N 1684 N202JTHour Time Machine LLC · Bloomington, INBuilt 2002 · S/N 0230 N202LSKsx Aviation Services LLC · San Francisco, CABuilt 2004 · S/N 40.459 N202TKGreater Sky Properties LLC · St Charles, MOBuilt 2025 · S/N 11088 N20352035 Holdings LLC · North Las Vegas, NVBuilt 2007 · S/N 3257462 N203APHi-Tech Air Holdings LLC · Austin, TXBuilt 2010 · S/N 4697444 N203CAStrasbaugh Development Corp · San Luis Obispo, CABuilt 1997 · S/N 4636102 N203CDMustarrow Inc Trustee · Wilmington, DEBuilt 2004 · S/N 1451 N203DAerotres LLC · Lakeville, MNBuilt 2020 · S/N 2881425 N203DSSouth Mountain Aero LLC · Myerstown, PABuilt 2002 · S/N 40.203 N203EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020118 N203FSpace Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 288416083 N203LTBonventre Michael J · Greentown, PABuilt 2019 · S/N 2479 N203PCEaton Brothers Transportation LLC · Riverside, MOS/N LW-258 N203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 1976 · S/N LW-203 N203RFRapid Flyers LLC · Rapid City, SDBuilt 2003 · S/N 0453

Back to AD 2008-06-28 R1