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.

N5329SAlabama Forestry Commission · Montgomery, ALBuilt 2003 · S/N 18281198N532EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13159N532HFJet Air Inc · Iowa City, IABuilt 2000 · S/N 17280836N532NDAia Bravo LLC · Henderson, NVBuilt 2011 · S/N 172S11102N5330AGila Aviation LLC · San Luis, AZBuilt 2003 · S/N T18208190N5330UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILFirst renewal noticeBuilt 2003 · S/N 17281152N53310Lucente Michael A · Fort Myers, FLBuilt 2003 · S/N 18281199N5331GAero Tech Services Inc · Lititz, PABuilt 2003 · S/N 172S9335N5331KChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9337N5331TGilchrist William J · Hodges, SCBuilt 2003 · S/N 172S9338N5332VMinuteman Aviation Inc · Missoula, MTBuilt 2003 · S/N 172S9341N53340N53340 LLC · Boynton Beach, FLBuilt 2003 · S/N 17281160N5334KGlen Dale L · Ferndale, WABuilt 2003 · S/N T18208193N5334UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281156N53352Fat Boy Air Sales & Leasing LLC · Naples, FLS/N 172S9352N5335GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281158N5335JFirst Eclipse Limited · Richmond, VABuilt 2003 · S/N 172S9347N5335SSpartan Education LLC · Tulsa, OKBuilt 2003 · S/N 172S9349N53372Clover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281170N5338NRaritan Valley Flying School · Princeton, NJBuilt 2003 · S/N 172S9358N5339MM&M Management Group LLC · Englewood, COBuilt 2003 · S/N 172S9359N533BMGray Ronald P · Glendale, AZBuilt 1999 · S/N 172S8340N533KSKent State University · Stow, OHBuilt 2012 · S/N 172S11240N5340XAgvest LLC · Abingdon, VABuilt 2003 · S/N 18281207N53417Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 17281162N5341GRyno Works Inc · Mccall, IDBuilt 2003 · S/N T18208195N5342QBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281153N5342TLima-001 LLC · Muscatine, IABuilt 2003 · S/N 172S9360N5342YAmeriflyers Of Texas Inc · Addison, TXBuilt 2003 · S/N 172S9361N53440Air Spacers Inc · Santa Monica, CABuilt 2003 · S/N 172S9365N5344FWingsleasing LLC · Wichita, KSS/N 172S9363N5345UMidwest Avtech Inc · South Barrington, ILS/N 18281210N53460L & W Leasing LLC · Smyrna, TNBuilt 2003 · S/N 172S9351N53468Maya Aircraft Holdings LLC · Lee, NHBuilt 2003 · S/N 172S9394N53474Executive Air Taxi Corp · Bismarck, NDBuilt 2003 · S/N 172S9376N5348EDexter Brady R · Chambers, NEBuilt 2003 · S/N 18281212N5349HAviation Advisor Inc · Kenosha, WIBuilt 2003 · S/N T18208198N534DDVan Gasse Randall M · Norway, MIBuilt 1998 · S/N 17280323N534EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13165N534HFSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280832N534KSKent State University · Stow, OHBuilt 2012 · S/N 172S11241N534RHAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13473N5352ULittle Dog Aviation LLC · Anchorage, AKBuilt 2003 · S/N 172S9385N5353RSouthern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281157N5355FFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2003 · S/N 17281166N5355WN5355w Partners LLC · Lehi, UTBuilt 2003 · S/N 17281167N53569New Horizon Aviation Inc · Warwick, RIBuilt 2003 · S/N 172S9395N5356PChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9393N53576Venbro Holdings LLC · Brooklyn, NYS/N 172S9398N53577New Horizon Aviation Inc · Warwick, RIBuilt 2003 · S/N 172S9399
Back to AD 2005-05-53 R1