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.

N964LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12034N964SPDirty Side Down Aviation LLC · Georgetown, TXBuilt 1999 · S/N 172S8176N964WFTempietto Inc · Aptos, CABuilt 2003 · S/N 18281291N965AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12480N965BBBascom Kimber Keith · Mckinney, TXBuilt 2013 · S/N 172S11251N965CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281965N965EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13013N965LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12035N966ACWhiskey Charlie Aero LLC · Poway, CABuilt 2001 · S/N 172S8845N966AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12481N966CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281966N966LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12036N967CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281967N967LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12037N967SAElizabeth City State University · Elizabeth City, NCBuilt 2002 · S/N 172S9067N968CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281968N968LLewis University · Romeoville, ILBuilt 2006 · S/N 172S10148N968LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12038N968SPMindy Limited LLC · Muscatine, IABuilt 1999 · S/N 172S8170N969FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10373N969LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12039N969SPB R S Leasing Inc · Wilmington, DEBuilt 1999 · S/N 172S8171N96FASilver Express Co · Miami, FLBuilt 2005 · S/N 172S10002N96FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13205N96GTVan Bortel Aircraft Inc · Arlington, TXBuilt 2012 · S/N T18209072N96TYAerospace Trust Management LLC Trustee · Wilmington, DES/N 18283361N970CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281970N970LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12040N9710ASky Mobility LLC · Warrington, PABuilt 2006 · S/N 172S10149N9710FAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280017N9713FDhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280018N9715FPlock Cory J · Southbury, CTBuilt 1997 · S/N 17280030N971CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281971N971KCDenventures Aviation LLC · Wheat Ridge, COBuilt 2000 · S/N 17280971N971TABanner Aviation LLC · Trabuco Canyon, CABuilt 2002 · S/N 172S9170N971THSanders Aviation Inc · Jasper, ALBuilt 2023 · S/N 172S12971N972BBBig Red Buffalo LLC · Hagerman, IDBuilt 2005 · S/N 172S10052N972FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13462N972GJPolk County Sheriffs Office · Winter Haven, FLBuilt 2006 · S/N 18281843N972KCMustang Sally Aviation LLC · Camden, SCBuilt 2000 · S/N 17280972N972TAConfluence Systems Consulting · San Jose, CABuilt 2002 · S/N 172S9171N972THUtah State University · Logan, UTBuilt 2023 · S/N 172S12972N972WWChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2002 · S/N 172S9072N9730FN9730f LLC · Boynton Beach, FLS/N 17280032N9731FN9731f LLC · Stuart, FLBuilt 1997 · S/N 17280035N973BCBattle Creek Flyers LLC · Battle Creek, MIBuilt 1997 · S/N 17280041N973EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13016N973HAAb Prop Plane I LLC · Metairie, LABuilt 2005 · S/N 172S9975N9741FAa-Aero Inc · Fairfield, NJBuilt 1997 · S/N 17280036N9744DTom Wood Aviation Inc · Fishers, INBuilt 1997 · S/N 17280260
Back to AD 2005-05-53 R1