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.

N266MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881364 N266RSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1703 N266SRRf Aviation LLC · Eaton, COBuilt 2007 · S/N 2626 N266TAlpha Zulu Holdings LLC · Arlington, VABuilt 2004 · S/N 4697188 N267AAWings Over Texas Holdings LLC · Denton, TXBuilt 2019 · S/N 4496482 N267CDTsp Aviation LLC · North Fort Myers, FLBuilt 2003 · S/N 1284 N267CPVanesian Bryan Dean · Apple Valley, CABuilt 2008 · S/N 3047 N267DHInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28-8190141 N267DSRc Aviation LLC · Pikeville, KYBuilt 2006 · S/N 1667 N267MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881365 N267NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842067 N267PKRegistration Pending · Summerville, GARegistration pendingBuilt 2014 · S/N 4156 N2680MRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1977 · S/N 28-7890261 N26893Goodman Harold Wayne · Clovis, CAS/N 28R-30679 N268BGHuff Holdings LLC · Ashland, KYBuilt 1976 · S/N 28-7690268 N268CDKahng Jim · Torrance, CABuilt 2003 · S/N 0436 N268DASpartan Education LLC · Tulsa, OKBuilt 2002 · S/N 4496135 N268DSJaw Aviation LLC · Rochester, NYBuilt 2012 · S/N 40.1143 N268DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010068 N268MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881366 N268RPTag Ag 04 LLC · Richmond, TXBuilt 2011 · S/N 4636511 N268SRCirrus Design Corp · Duluth, MNBuilt 2007 · S/N 2334 N268WGolf Links Inc · Hermitage, TNBuilt 2006 · S/N 42542 N2694GInspec Aviation Inc · Schwenksville, PABuilt 1980 · S/N 28-8090230 N269CDMclaughlin John · Palm Harbor, FLBuilt 2002 · S/N 1204 N269DSSun Jingchao · Oxnard, CAS/N 40.269 N269DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010069 N269JJBas Part Sales LLC · Greeley, COBuilt 2019 · S/N 2487 N269JMPatterson Larry Jay · San Angelo, TXBuilt 2008 · S/N 3231 N269KMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020099 N269LSSky King LLC · West Fargo, NDBuilt 1981 · S/N BB-799 N269MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881367 N269MLAtlantic Wings LLC · New Bern, NCBuilt 1980 · S/N BB-760 N269MPGustafson H Clayton · Woodbury, CTBuilt 1980 · S/N 32R8029007 N269RBRomeo Bravo Holdings LLC · Brooklyn, NYBuilt 2006 · S/N 40.740 N269TSDewey Phillip · Austin, TXBuilt 2022 · S/N 8847 N269ZIziair LLC · Mclean, VABuilt 2006 · S/N 3257407 N26BZNorthcutt Chevrolet Buick LLC · Enid, OKBuilt 2014 · S/N 4033 N26DPColibri Ventures LLC · Dorado, PRBuilt 2021 · S/N 5138 N26DRPepper Equipment Corp · Monte Vista, COBuilt 2008 · S/N 4697358 N26EDynamic Avlease Inc · Bridgewater, VAS/N LW-62 N26KCInternational Air Services Inc Trustee · Carson City, NVS/N 4697113 N26MWMike Whiskey LLC · Atlanta, GABuilt 2026 · S/N 11187 N26PGSan Angeles Aviation LLC · Phoenix, AZFirst renewal noticeBuilt 1990 · S/N 4622117 N26TGKenmore Crew Leasing Inc Trustee · Bellingham, WAFirst renewal noticeBuilt 1999 · S/N 4636193 N26VBSky Safety Inc · San Antonio, TXBuilt 2006 · S/N 40.630 N26VSBoss Aviation LLC · Douglas, AZBuilt 2009 · S/N 3585 N26WRiddle Jay Allen · Gainesville, FLBuilt 2020 · S/N 4905 N26WMSportcruiser LLC · Wilmington, DEBuilt 2021 · S/N 5002 N2704SC&M Asset Management LLC · Owasso, OKBuilt 2005 · S/N 1265

Back to AD 2008-06-28 R1