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.

N5210AChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9118N5210QFortress Group LLC · Thompsons Station, TNBuilt 2002 · S/N 18281140N52128Glasslane LLC · Wilmington, DES/N T18208158N5212XMoore John S · Strafford, NHBuilt 2002 · S/N 172S9120N5213FJefferson City Aviation Inc · Jefferson City, MOBuilt 2002 · S/N 172S9124N5213MFlight Training Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 172S9127N5215JIndigo Air LLC · Newburgh, NYBuilt 2002 · S/N 172S9128N5216ULeopard Air LLC · Oklahoma City, OKBuilt 2002 · S/N 172S9130N5218FMacmillan Performance LLC · Torrance, CABuilt 2002 · S/N 172S9132N5218UWnc Aviation LLC · Arden, NCS/N 172S9133N5218YMcintire Aviation LLC · Middletown, DEBuilt 2002 · S/N 18281147N5219VSkymates Inc · Wilmington, DEBuilt 2002 · S/N 172S9138N521AFChhh LLC · Raleigh, NCBuilt 2003 · S/N 18281194N521CAAftcloud Inc · Ontario, CABuilt 2004 · S/N 172S9733N521DBBowling Donald W · Greensburg, INBuilt 2006 · S/N 18281823N521EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12623N521ER521er LLC · Blaine, MNBuilt 2001 · S/N 172S8924N521JDH&G Farms Inc · Corcoran, CABuilt 1998 · S/N 172S8027N521JTDeralex Airways LLC · Miami, FLBuilt 1998 · S/N 172S8013N521KSKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 17280519N521MCBarr Air Patrol LLC · Mesquite, TXBuilt 2004 · S/N 172S9730N521NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10975N521SDMedary Aviation LLC · Brookings, SDBuilt 2024 · S/N 172S13137N521TKCato Air LLC · Wilmington, DEBuilt 2005 · S/N 18281673N52208Eastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9208N5220AMarshall Chadwick J · Fort Walton Beach, FLBuilt 2002 · S/N 18281149N5222GHanger C16 LLC · Pinckney, MIBuilt 2002 · S/N T18208164N52232Mustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10870N52241Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10879N5224EFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10875N5224GBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 172S9144N5225LFirst Aero LLC · Edmonds, WABuilt 2002 · S/N 18281151N5225REnright Darren · Lakeville, MNBuilt 2002 · S/N 18281152N5225YGarret G Enterprises LLC DBA · Lakewood, COBuilt 2002 · S/N T18208165N52262Skymates Inc · Wilmington, DES/N 172S9412N5226DFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10880N5227SDcrss LLC · Marcy, NYBuilt 2009 · S/N 18282155N522AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281195N522CSKarpinski Arthur A · Jordan, NYBuilt 2016 · S/N 18282422N522EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12868N522NDSpartan Education LLC · Tulsa, OKBuilt 2009 · S/N 172S10977N522QFFlight Training Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 17280216N522RARaven Aircraft LLC · Prescott, AZS/N T18208689N522SDSouth Dakota State University · Brookings, SDBuilt 2022 · S/N 172S12920N522VSArq Aviation LLC · Wilmington, NCBuilt 2022 · S/N 172S12907N52340Textron Aviation Inc · Wichita, KSS/N 172S13639N5236UVan Bortel Aircraft Inc · Arlington, TXBuilt 2009 · S/N T18208946N5236VT And G Investments LLC · Gulfport, MSBuilt 2009 · S/N T18208950N5237YWerninghaus Karla I · Reno, NVBuilt 2009 · S/N T18208951N5238HGalatians182 LLC · Kalispell, MTBuilt 2009 · S/N T18208948
Back to AD 2005-05-53 R1