OpenAirDocs.org
AD 2005-05-53 R1

Registered aircraft · 6,038

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:2005-05-53-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:2005-05-53-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.

N858YTChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12266N858ZKChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12267N859CPN859cp LLC · Boynton Beach, FLBuilt 1999 · S/N 17280540N859DAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12568N859JTRainier Flight Service LLC · Renton, WABuilt 2019 · S/N 172S12246N859RGVan Bortel Aircraft Inc · Arlington, TXS/N T18208391N859SPJet Air Inc · Iowa City, IABuilt 2001 · S/N 172S8762N85ESProsser Rodney W · Columbia, NJBuilt 2006 · S/N T18208633N85FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12949N860AATextron Aviation Inc · Wichita, KSS/N 172S13623N860AUAuburn University · Auburn, ALBuilt 2019 · S/N 172S12293N860CPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280557N860SASaint Clair Flight Academy Inc · Richmond, MIBuilt 2001 · S/N 172S8860N860SPRegistered aircraftBuilt 1999 · S/N 172S8131N860TWSun City Air Charter LLC · Davie, FLBuilt 2002 · S/N 172S9220N861AATextron Aviation Inc · Wichita, KSS/N 172S13624N861ATChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12411N861AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12469N861CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283343N861EREmbry-Riddle Aeronautical Univserity Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13233N861SFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 18281438N862AUAuburn University · Auburn Univerity, ALBuilt 2020 · S/N 172S12470N862CPN862cp LLC · Stuart, FLBuilt 1998 · S/N 17280566N863AUBas Part Sales LLC · Greeley, COBuilt 2020 · S/N 172S12471N863PAUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2002 · S/N 172S9062N863SPLegacy Aviation LLC · Tea, SDBuilt 1999 · S/N 172S8122N864AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12472N864CKTabatabai Seyed Ali · Houston, TXBuilt 2005 · S/N 172S9864N864CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281854N864SPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeBuilt 1999 · S/N 172S8123N865CKAero American Flight LLC · Houston, TXBuilt 2014 · S/N 172S11466N865CPAmr Holdings LLC · Kalispell, MTBuilt 1998 · S/N 17280602N865CWSouthern Aviation · Anchorage, AKFirst renewal noticeBuilt 2005 · S/N 18281537N865DAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12569N865GWMountain West Select Inc · Ammon, IDS/N T18208065N865JPVista Valley Aviation LLC · Ririe, IDBuilt 2012 · S/N T18209065N865PAPlatinum Angel LLC · Melbourne, FLBuilt 2006 · S/N 172S10176N865TCQuinault Aviation LLC · Priest River, IDS/N 18282276N866CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12634N866TTSgw Aviation LLC · Hastings, MIBuilt 2018 · S/N 18283042N867CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11589N867EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12675N867LAHillsboro Aero Academy LLC · Hillsboro, ORS/N 172S8941N867MMMenzel Electric Inc · Mingo Junction, OHBuilt 2004 · S/N T18208274N868SPWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 172S8128N868TBSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9311N868TCDlg Enterprises LLC · Iota, LABuilt 2002 · S/N 18281168N869CPExecutive Flight Institute LLC · Murrieta, CABuilt 1999 · S/N 17280641N869EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12679N869FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10346
Back to AD 2005-05-53 R1