OpenAirDocs.org
AD 2005-05-53 R1

Registered aircraft · 6,035

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.

N186TABraden Health LLC · Greensboro, NCBuilt 2018 · S/N 18283030N18728Atlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 172S9929N187CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13102N187HSGlidewell Aviation Inc · Parkland, FLBuilt 2005 · S/N 172S9945N1882SWings Over L A Aviation LLC · West Hills, CABuilt 2005 · S/N 172S9930N1884MMontgomery Aviation LLC · Zionsville, INBuilt 2005 · S/N 172S9931N188AHAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13467N188CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283260N188CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282343N188VEFly Skyhawk LLC · Peoria, AZBuilt 2000 · S/N 172S8391N1896BSmart John B III · Southlake, TXBuilt 2005 · S/N 18281731N189CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281989N189JPMontana Skies LLC · Kalispell, MTBuilt 2011 · S/N T18209053N18ACHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 172S9737N18HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281071N18LWDirty Side Down Aviation LLC · Georgetown, TXBuilt 1998 · S/N 17280403N190LPAmeriflyers Of Texas Inc · Addison, TXBuilt 2002 · S/N 172S9190N190MEMenagerie Enterprises Inc DBA · Denison, TXBuilt 2012 · S/N 172S11190N1916JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13182N19194Smokey Bear Air LLC · Cascade Locks, ORBuilt 2005 · S/N T18208428N1919UD&S Aviation LLC · Spring, TXBuilt 2025 · S/N 172S13295N191CACsa Aircraft Leasing LLC · Salt Lake City, UTS/N 17281243N191FAHarvey Taz E · Danville, CABuilt 2003 · S/N T18208191N1926REmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2025 · S/N 172S13436N19277Roundtree Sod Service Inc · Jacksonville, FLBuilt 2005 · S/N T18208437N192JPBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2005 · S/N 172S9894N192MCWarrington Flying Club Inc · Doylestown, PABuilt 2006 · S/N 172S10162N192MEKindrick Jan W · Mt Vernon, TXBuilt 2000 · S/N 172S8454N192TGSaz Dynamics LLC · Daly City, CABuilt 2005 · S/N 18281524N1931HMountain Air Aviation LLC · Fruit Heights, UTBuilt 2006 · S/N 172S10128N1934GAero-Tech Services Inc · Lititz, PABuilt 2006 · S/N 172S10129N19369Aci Aviation LLC · Costa Mesa, CABuilt 2006 · S/N 172S10130N1939SFallon Timothy · Center Barnstead, NHBuilt 2005 · S/N 172S9974N193MEHorizon Flight Center LLC · Chesapeake, VABuilt 2000 · S/N 172S8458N193THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11551N193VBAli Suleiman Md Inc · Beckley, WVBuilt 2013 · S/N T18209093N1941BSan LLC · Knoxville, TNBuilt 2021 · S/N 18283158N1947LCal Aggie Flying Farmers · Davis, CABuilt 2016 · S/N 172S11765N194SPFly4sp LLC · San Mateo, CABuilt 2003 · S/N 172S9459N194THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11552N1955TFredericksen John · Cedarburg, WIBuilt 2021 · S/N 18283157N1956VMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9934N1957KVan Bortel Aircraft Inc · Arlington, TXBuilt 2013 · S/N T18209091N195FAPinkston Pat · Carrollton, ILBuilt 2002 · S/N 18281095N195NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11095N1965HDeltahawk Engines Inc · Racine, WIBuilt 2005 · S/N 172S9937N196MEPacific Lease · Elk Grove, CABuilt 2000 · S/N 172S8471N196PWC I Mckown & Son Inc · Newton, WVBuilt 2004 · S/N 18281368N197BALewis University · Romeoville, ILBuilt 1997 · S/N 17280314N197MCLewis University · Romeoville, ILBuilt 2006 · S/N 172S10197
Back to AD 2005-05-53 R1