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.

N53020Iasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281136N5302XFnb Flying Club LLC · Gallatin, TNS/N 18281175N53039Laurel Highlands Aeronautical Academy · Latrobe, PAS/N 172S9259N5303JGulf Coast Aviation LLC · New Orleans, LABuilt 2002 · S/N 172S9254N5303TMorey Airplane Co Inc · Middleton, WIBuilt 2002 · S/N 172S9255N53068Legends Air Center LLC · Bentonville, ARBuilt 2002 · S/N 172S9265N5306CSo Cal Leasing LLC · El Cajon, CABuilt 2002 · S/N 172S9269N5306UAircraft Solutions Group LLC · Englewood, COBuilt 2002 · S/N 172S9264N53070Wnc Aviation LLC · Arden, NCBuilt 2003 · S/N 172S9325N53076Rjr Aviation LLC · Ridge, NYS/N 18281179N53098Carlson Robert A Trustee · Rosamond, CABuilt 2003 · S/N T18208187N5309FMedary Aviation LLC · Brookings, SDS/N 172S9273N5309VFlight Training Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 172S9274N530AUWateractive43 LLC · Auburn, CABuilt 2002 · S/N 172S9225N530ERZima Aviation LLC · Huntington, CABuilt 2002 · S/N 172S9113N530MBBrill Nathan · Austin, TXBuilt 2019 · S/N 18283063N530MTAcron Aviation Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10569N530NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10829N530PSSpartan Education LLC · Tulsa, OKBuilt 2005 · S/N 172S9859N530SCFoxtrot Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13353N530TC530tc LLC · Nashville, TNBuilt 2022 · S/N 18283192N53116Wnc Aviation LLC · Arden, NCBuilt 2002 · S/N 172S9283N5311HBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 172S9278N5312KDelta State University · Cleveland, MSBuilt 2003 · S/N 17281143N5312SGace Flying Club · Ronkonkoma, NYBuilt 2002 · S/N 172S9285N5312VBounds Justin M · Houston, TXBuilt 2003 · S/N 172S9287N53143Delta State University · Cleveland, MSBuilt 2003 · S/N 17281145N5314RDelta State University · Cleveland, MSBuilt 2003 · S/N 17281144N5315EEastern Cincinnati Aviation Inc · Batavia, OHS/N 172S9291N5316GBerg Philip L · Chatsworth, CAS/N 172S9294N53176Perfect Agreements Leasing Inc · Trabuco Canyon, CAS/N 172S9299N5318GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281155N531EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13069N531LGMills Daniel L · Manchester, MIBuilt 1997 · S/N 17280056N531NDN531nd LLC · Sammamish, WABuilt 2011 · S/N 172S11101N53205Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 172S9307N53214Westbank Fishing LLC · Kiln, MSS/N 18281171N5321AJust Plane Stuff Inc · Jackson, MSBuilt 2003 · S/N 172S9308N5322PSky Peak Aviation LLC · Los Angeles, CABuilt 2003 · S/N 172S9312N53237Jet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9314N5324GFloris Flight Services LLC · Midland, TXBuilt 2003 · S/N 172S9315N5325NSchindler Lawrence A · Chino Valley, AZBuilt 2003 · S/N 172S9317N5327GDirty Side Down Aviation LLC · Georgetown, TXS/N 172S9357N5327JEdb Air Inc · Wilsonville, ORBuilt 2003 · S/N 172S9356N5327UJa Williams Investments LLC · Austin, TXBuilt 2003 · S/N T18208188N5327VSouthern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281151N53289Christiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9331N5328YGa Holdings LLC · Moffett Field, CAS/N 172S9270N5328ZBartow Municipal Airport Development Authority · Bartow, FLBuilt 2003 · S/N 172S9327N53291North Country Aviation Service LLC · Lewes, DEBuilt 2007 · S/N T18208710
Back to AD 2005-05-53 R1