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.

N76JFParfet Aviation LLC · Pacifica, CABuilt 2022 · S/N 8825N76KJA&D Terminal Management LLC · Towaco, NJBuilt 2012 · S/N 4697502N76MGCook Brothers Farms LLC · Princeton, KYBuilt 2001 · S/N 4697056N76PFRodriguez Amable Omar · Hialeah, FLBuilt 1982 · S/N 28-8216151N76SVParish Aviation LLC · New Orleans, LABuilt 2020 · S/N 4986N76TDWillmott Wilson R · Huntington Station, NYBuilt 1979 · S/N 32R-8013027N76VBPiper Aircraft Inc · Vero Beach, FLS/N 4697732N7701AEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 4496089N7702BSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496090N7702HPaphos Airways LLC · Farmingdale, NYBuilt 2003 · S/N 2843568N7702LPrp Enterprises LLC · Lake Forest, CABuilt 1980 · S/N 32R-8013104N7703CEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 4496091N7704DSkyborne Airlines Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496092N7707GAtd Pilot Training LLC · Kansas City, MOBuilt 2001 · S/N 4496096N7709JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496100N770ALAviation Company Inc · Cheyenne, WYBuilt 1979 · S/N BB.77N770CAHorse Hill LLC · Napa, CABuilt 2009 · S/N 3418N770CTMetza M Kristen · Andrews, NCBuilt 2008 · S/N 2927N770GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881207N770MMButterworth James Blakely · Demorest, GABuilt 2009 · S/N 3405N770NDN770nd LLC · Sidney, MTBuilt 2016 · S/N 2843862N770PRPuerto Rico International Airline Inc · Santurce, PRBuilt 1978 · S/N 28-7816510N770RSPlesant Maurice P · El Paso, TXBuilt 2002 · S/N 40.240N770SRRiverside Aircraft LLC · Fort Myers, FLBuilt 2006 · S/N 1939N770TPJekkerson LLC · Evergreen, COBuilt 2007 · S/N 2418N7710KAtd Pilot Training LLC · Kansas City, MOBuilt 2001 · S/N 4496101N7711YM Three Fly LLC · Jacksonville, FLBuilt 2008 · S/N 411059N7714CLuebow Jens · Madison, WIBuilt 1975 · S/N 28-7690078N7717VCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496120N7719XBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4496130N771BTRosen Air 71 LLC · Brentwood, TNBuilt 2010 · S/N 3622N771CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881739N771KSWieczorek Michael A · Athens, GABuilt 2005 · S/N 1717N771LMBruntjen Eric · Decatur, ILBuilt 1982 · S/N 32R-8229044N771NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881036N771RANational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 2841154N771SL3vr Aviation LLC · Annapolis, MDBuilt 2005 · S/N 1405N771SRN771sr Inc Trustee · Wilmington, DEBuilt 2007 · S/N 2771N7720YEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 4496132N7724THedding/Neff Aviation LLC · Moore, OKS/N 1266N7728ALynch James Kevin · Forsyth, GABuilt 2004 · S/N 1454N772CManitoba Pacific LLC · Laguna Niguel, CABuilt 2002 · S/N 0401N772CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881740N772CCWagner William · Oro Valley, AZBuilt 2005 · S/N 1539N772CDHarllee Cattle Company LLC · Bradenton, FLBuilt 2005 · S/N 1403N772DSCharleston Aviation Inc · Charleston, ILBuilt 2002 · S/N 4636338N772NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881037N772TTBrightwater Enterprises LLC · Lakeway, TXBuilt 2004 · S/N 42058N772VBSkybone Airline Academy Inc · Vero Beach, FLBuilt 2023 · S/N 28020105N772WSSouthwest Technology Center School District No. 27 · Altus, OKBuilt 1967 · S/N 28R-30083
Back to AD 2008-06-28 R1