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.

N800VVCarver Aero LLC · Muscatine, IABuilt 1981 · S/N 28-8216080N800ZHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2014 · S/N 4692209N8017CBluedevil Aviation LLC · Scottsdale, AZBuilt 1981 · S/N 34-8133200N8017DPepper Enterprises LLC · El Paso, TXBuilt 2003 · S/N 1339N8018NMacris Troy C · Tarpon Springs, FLBuilt 1981 · S/N 28-8216082N8019VJuliet One LLC · Newark, DEBuilt 1981 · S/N 28-8290074N801AGPanther Tamer Aviation LLC · Las Vegas, NVBuilt 2025 · S/N 10632N801FCN801fc LLC · Belle Chasse, LABuilt 1980 · S/N 28-8016285N801GAOn 2 Abaco LLC · Leesburg, FLBuilt 1998 · S/N 3246107N801SW5b Aviation LLC · Duncan, OKBuilt 1979 · S/N 447995209N8024AJakubik Joshua D · Magnolia, TXS/N 32R-8313008N8024DAbcon Automation Inc · Harrison, OHS/N 32R-8213004N8024QFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496519N8024YValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 32R-8229018N802ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496330N802CDTs Flight LLC · Saint Louis Park, MNBuilt 2001 · S/N 0103N802CMN802cm LLC · Lebanon, MOBuilt 2002 · S/N 2843541N802CSAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2006 · S/N 1935N802ERValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 40.306N802FPFunctional Pathways Preferred Of Tennessee LLC · Knoxville, TNBuilt 2006 · S/N 1930N802MMAuburn Air Leasing LLC · Kalispell, MTBuilt 2002 · S/N 4697148N802NXLacey David G · Locust Grove, GABuilt 2004 · S/N 1222N802RCCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 28R-30299N802SRBohon Jose S · Corona, CABuilt 2006 · S/N 1886N802SSBlue Sky Inc · Wilmington, DEFirst renewal noticeBuilt 2005 · S/N 41063N8032CAirwego LLC · Wilmington, DEBuilt 1975 · S/N 28-7690097N8033HArde Wayne A · Simla, COBuilt 2003 · S/N 0644N80349Giles Jonathan P · Fountain Inn, SCBuilt 1981 · S/N 32R-8213020N80368Registration Pending · Augusta, KSRegistration pendingBuilt 1981 · S/N 28-8216085N8036DN 8036d LLC · Brownsburg, INBuilt 1981 · S/N 32R-8213021N803ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496332N803EAK2 Aviation LLC · Greenwood Village, COBuilt 2018 · S/N 2435N803ERBenson Catrina D · Palmdale, CABuilt 2003 · S/N 40.307N803MEMaine Instrument Flight · Augusta, MEBuilt 2023 · S/N 9527N803PFlight1 Technical Training Services LLC · Myrtle Beach, SCBuilt 2019 · S/N 2526N803PKCarnine Legal Pllc · Mount Vernon, ILBuilt 2021 · S/N 5048N803SRInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 1959N803WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10156N804Abc Aviation LLC · Gonzales, LABuilt 1980 · S/N BB-724N8041BIchtou LLC · Dover, DEBuilt 1981 · S/N 32R-8213022N8041HKing Ag Leasing Inc · Sudan, TXBuilt 1981 · S/N 32R-8229022N8041MLewis Edward H · Moorestown, NJBuilt 1981 · S/N 32R-8229023N8042GTemple In The Sky LLC · Marietta, GABuilt 1981 · S/N 32R-8229024N80441Archer Aircraft LLC · Wilmington, DEBuilt 2019 · S/N 2881235N8044TArcher Aircraft LLC · Wilmington, DEBuilt 2019 · S/N 2881234N8045NCti Aircraft Leasing LLC · Memphis, TNBuilt 2019 · S/N 4496488N8047SRisso Christopher W · Huntington Beach, CABuilt 1981 · S/N 32R-8229025N8048QWings Of Hope · St Louis, MOS/N 34-8233064N804AFBlue Pearl Ventures LLC · Eighty Four, PABuilt 2021 · S/N 4636791N804ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496333
Back to AD 2008-06-28 R1