OpenAirDocs.org
AD 2008-06-28 R1

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
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.

N8295ZWhitaker Stephen P · Northville, MIBuilt 1980 · S/N 28-8190087N82967Spare Joseph T · Waldo, OHBuilt 1980 · S/N 32R-8113013N8299VKoushall Marlon S · Finksburg, MDBuilt 1980 · S/N 32R-8113014N829CJetran LLC · Horseshoe Bay, TXBuilt 2005 · S/N 3255039N829CDAviate Piloot Academy LLC · Wichita, KSBuilt 2002 · S/N 1256N829CFKendrick Consulting LLC · Hayden, IDBuilt 2010 · S/N 3683N829CN3771r LLC · Lockport, NYBuilt 2011 · S/N 3764N829DXuno Group LLC · Fort Lauderdale, FLBuilt 2023 · S/N 9127N829DMValiair Lc Trustee · Casper, WYBuilt 2022 · S/N 8729N829DSSuperfortress LLC · Hampstead, NCBuilt 2007 · S/N 40.849N829JCirrus Design Corp · Duluth, MNS/N 11994N829JSRedstone Arsenal Flying Activity · Huntsville, ALBuilt 2001 · S/N 2842123N829KAMccallum Aviation LLC · Chehalis, WABuilt 2012 · S/N 4636530N829LSStarkys Equipment Leasing LLC · Manchester, MIBuilt 1988 · S/N 3213011N829MMA Plus Construction Of Georgia Inc · Norcross, GABuilt 2020 · S/N 2647N829PKMainstay Distributing LLC · Norwalk, WIBuilt 2022 · S/N 8995N829RC829rc LLC · Lewes, DEBuilt 2018 · S/N 4725N829WBlue Sky Transport LLC · Deland, FLBuilt 2005 · S/N 1407N82BZTeuber Gary J · Sister Bay, WIBuilt 1982 · S/N 28-8390017N82DPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11554N82FGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 9001N82JRRoss Jerry Dean · Springfield, MOBuilt 2025 · S/N 10510N82KFAtlantic Aviation Services LLC · Cheyenne, WYBuilt 2015 · S/N 4636677N82KTK-T Industries Inc · Sheldon, IAS/N 32R-8129072N82LLSda Aviation LLC · Winnsboro, LABuilt 2000 · S/N 46-36289N82MVDelacerda Lucas Lane · Baton Rouge, LABuilt 2015 · S/N 4297N82MZN82mz LLC · Carlsbad, CABuilt 2024 · S/N 9921N82PHHarold Hart & Associates Inc · Tampa, FLBuilt 2005 · S/N 42082N82SAOrange Skies LLC · Falls Church, VABuilt 2004 · S/N 0902N82TEAir Urology LLC · Wadmalaw Island, SCBuilt 2006 · S/N 1817N82TMMkr Air LLC · Belleair, FLS/N 441-0104N82WHReed Joshua · Chesapeake, VABuilt 1981 · S/N 32R-8213026N83009Paris Air Inc · Vero Beach, FLS/N 28-8116088N8300JHepper Abby · Keene, NDBuilt 1980 · S/N 32R-8129010N83013Tjmc LLC · Riverbank, CABuilt 1980 · S/N 28-8116090N83016Maks97 LLC · Sparta, MIBuilt 1980 · S/N 28-8116091N83021Kosbruk Boris R Jr · Perryville, AKBuilt 1980 · S/N 28-8190104N8302A4 Moons Aviation Inc · Danvers, MABuilt 1980 · S/N 28-8116092N8302TYarb LLC · Cleburne, TXBuilt 1980 · S/N 28-8190103N83038Zimin Transportation LLC · South Naknek, AKBuilt 1980 · S/N 28-8116096N83039Macair Aviation LLC · Xenia, OHBuilt 1980 · S/N 28-8116097N8304KKrouse James · Cocoa Beach, FLS/N 28-8190107N8304LGarrai LLC · Rhinebeck, NYS/N 28-8190108N8306EBreidenbach Any · Onalaska, WIBuilt 1980 · S/N 32R-8129014N8307Prather Gregory Douglas · Boca Raton, FLBuilt 1980 · S/N 32R8113017N83076N83076 LLC · Wayne, PABuilt 1980 · S/N 28-8116102N8307YParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8116100N8308CN8308c LLC · Haymarket, VABuilt 1975 · S/N 28-7690113N8308LClassic Wings · Westlake Village, CAS/N 28-8316017N8308VCleary Paul D · Guilford, CTBuilt 1980 · S/N 32R-8129016
Back to AD 2008-06-28 R1