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.

N345WCEnriquez Antonio · Austin, TXBuilt 2023 · S/N T18209105N3469246dk LLC · Ramona, CABuilt 2004 · S/N T18208248N346BSGulf Coast Aviation LLC · New Orleans, LABuilt 2004 · S/N 172S9757N346CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13257N346CPPinnacle Aviation Services Inc · Encinitas, CABuilt 1998 · S/N 17280346N346KMitchell Flying Club Inc · Lees Summit, MOBuilt 1997 · S/N 17280064N346SPFlightline Air Service LLC · Pineville, LABuilt 1999 · S/N 172S8268N347LSEuroaviation Inc · KematenBuilt 2007 · S/N T18208749N347MENiemeyer Leasing LLC · Cave Creek, AZBuilt 2000 · S/N 172S8581N347SACoastal Carolina Helicopters LLC · Burgaw, NCBuilt 2006 · S/N T18208522N348CPHaddock Tracey P · Kingstree, SCBuilt 1998 · S/N 17280348N348MEBlackstone Aviation LLC · Irvine, CAFirst renewal noticeBuilt 2000 · S/N 172S8582N348SPSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1999 · S/N 172S8273N348TCWilliams Ryan D · Panama City, FLBuilt 2004 · S/N 18281434N349CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209029N349MEPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 172S8584N349SPWard Michael Allen · Quinlan, TXBuilt 1999 · S/N 172S8276N34BLAmerican Asset Leasing LLC · Aurora, ORBuilt 2020 · S/N 172S12468N34GSGhavi Enterprises Inc · Kenosha, WIBuilt 2016 · S/N 172S11662N34LGCruz Aviation LLC · Holmdel, NJBuilt 2021 · S/N 18283145N34UMMarathon Skylane LLC · West Palm Beach, FLS/N T18208561N3500FN3500f LLC · Jennings, LABuilt 2001 · S/N 18280994N3500MNagy Sandor · Monterey, CABuilt 2001 · S/N 18280996N3500RSystems Research Corp · Wilmington, DEBuilt 2001 · S/N T18208047N3500TSusanville Aviation LLC · Susanville, CABuilt 2001 · S/N T18208048N3501K3501k LLC · Southaven, MSS/N 172S8969N3502JAv Solutions Inc · Flint, MIS/N T18208058N3502QHarvest Aviation LLC · Yorba Linda, CAS/N T18208057N3503HRansom Woodbury S Trustee · Lansing, IAS/N 18281006N3504PWingsleasing LLC · Wichita, KSBuilt 2001 · S/N 17281053N3505TAa-Aero Inc · Fairfield, NJBuilt 2001 · S/N 172S8858N35063Purdue Aviation LLC · West Lafayette, INBuilt 2001 · S/N 172S8878N3506GDelta State University · Cleveland, MSBuilt 2001 · S/N 17281054N3506QEjair LLC · Shelburne, VTBuilt 2002 · S/N 18281108N3506TBaron Logistics LLC · Metairie, LABuilt 2001 · S/N 172S8962N35077Carreno Victor A · Guaynabo, PRBuilt 2001 · S/N 17281062N35079Wings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17281061N3508JDhs Operations LLC · Wilmington, DEBuilt 2001 · S/N 17281060N35092Iasco Flight Training Inc · Redding, CABuilt 2001 · S/N 17281044N3509QChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8835N350EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13081N350SUOhio State University · Columbus, OHBuilt 2019 · S/N 172S12304N35106Bradley Patrick C Trustee · Isleton, CAS/N T18208066N3510ACrotts Aircraft Service Inc · Dodge City, KSBuilt 2001 · S/N 17281042N3511FHardison Charles M · Granbury, TXBuilt 2001 · S/N 18281016N3511RWilliam E Boyle LLC · Pittsburgh, PABuilt 2001 · S/N 172S8880N35121Snohomish Flying Service Inc · Snohomish, WAS/N 172S8844N3512TBroadway Aircraft Management Inc · Merritt Island, FLS/N 172S8883N3513FBeeca Flight LLC · Oviedo, FLBuilt 2002 · S/N 17281090N3513TCrusade Investments LLC · Ardmore, OKS/N 18281049
Back to AD 2005-05-53 R1