OpenAirDocs.org
AD 2005-05-53 R1

Registered aircraft · 6,034

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.

N1552SZimmer Eric Fritz · Temecula, CABuilt 2007 · S/N T18208782N155FCState Of Florida · Tallahassee, FLBuilt 2006 · S/N 18281789N156Koche Gary · Downers Grove, ILBuilt 2012 · S/N T18209064N1568WDfb Holdings LLC · Coeur D Alene, IDS/N T18208394N156DWAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 172S8342N156MEArcher III LLC · Littleton, COBuilt 2000 · S/N 172S8435N157CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281857N157FCDepartment Of Agriculture & Consummer Services · Tallahassee, FLBuilt 2006 · S/N 18281875N157KCNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11037N157MEMaine Coastal Flight Center Inc · Bangor, MEBuilt 2000 · S/N 172S8436N1589DN1589d LLC · Stuart, FLBuilt 2005 · S/N 17281255N158CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281858N158CWMcdonald John C · Hallsville, TXBuilt 2004 · S/N 18281381N158FCDept Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2008 · S/N 18282062N158RAJohneco Inc · Beachwood, OHBuilt 1999 · S/N 17280805N158SFAlba Leasing Services LLC · Scottsdale, AZBuilt 2006 · S/N 172S10368N1590WCc Aviation Inc · Tracy, CABuilt 2005 · S/N 17281256N159CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281859N159FCDept Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2008 · S/N 18282065N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816N15ANAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13258N15MJRegistered aircraftBuilt 2024 · S/N 172S13005N15MVAir Bellers Inc · Sunnyvale, CABuilt 2017 · S/N 18282388N15SZZurcher Susan R · Hampshire, ILBuilt 2022 · S/N 18283202N1600UOsprey Holding Company LLC · Foley, ALBuilt 2005 · S/N 172S9905N1608SNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S9907N160MESilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172S8440N1615AAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9910N1621Diem Ronald · Myerstown, PABuilt 2025 · S/N 18283315N16237Main Line Assets LLC · Wayne, PABuilt 2005 · S/N 172S9912N1624Going Somewhere LLC · Dover, DEBuilt 2018 · S/N 18283056N162CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13489N162JKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13466N162MEIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 172S8442N163AWMccall Andrew Keith · Abilene, TXBuilt 2002 · S/N T18208163N163CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13492N163CTRenson Travel LLC · San Antonio, TXBuilt 2016 · S/N 18282390N163DDN163dd LLC · Columbus, MTBuilt 2007 · S/N T18208707N163MEAircraft Owners And Pilots Association Inc · Frederick, MDBuilt 2000 · S/N 172S8444N1641CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11753N1643CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11754N1646CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11729N1648CCoast Aviation LLC · Costa Mesa, CABuilt 2016 · S/N 172S11678N164BDRuffin Robert L Jr · Mabank, TXBuilt 2004 · S/N 18281459N164CWMudd Joe · Tucson, AZBuilt 2004 · S/N 18281325N1651CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11755N1658CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11756N165ARLago Enterprises LLC · Centennial, COBuilt 1998 · S/N 172S8018N165CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281865N165YPSpanaflight LLC · Puyallup, WABuilt 1999 · S/N 17280752
Back to AD 2005-05-53 R1