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.

N35148Century Air Inc · Fairfield, NJBuilt 2001 · S/N 172S8930N3514TAlpha Sierra Aviation LLC · Wilmington, DES/N 172S8843N3514UChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8841N3517SG & M Aircraft Inc · Wheat Ridge, COBuilt 2001 · S/N 17281083N3517VSt Cloud State University Aero Club Inc · Saint Cloud, MNBuilt 2001 · S/N 17281082N35183Stone Industrial Contractors Inc · Savannah, GABuilt 2001 · S/N 18281051N35184Maliszewski William F · Independence, WIBuilt 2001 · S/N 18281002N35188Landsearch LLC · Wilmington, NCS/N 18280999N3518WMoriah Hills LLC · Aurora, ORS/N T18208084N3519FVan Bortel Aircraft Inc · Arlington, TXS/N T18208050N3519UG And D Aviation LLC · Sunfish Lake, MNS/N 172S8849N351CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283311N351CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281386N351JSRainier Flight Service LLC · Renton, WABuilt 2025 · S/N 172S13355N351LKK-Air Inc · Egg Harbor, WIBuilt 2025 · S/N T18209190N351MEPs N351me LLC · Green Bay, WIBuilt 2000 · S/N 172S8586N351SSGill David · Bellingham, WABuilt 2008 · S/N T18208823N35206Mosaic Aviation LLC · Pelham, ALBuilt 2001 · S/N T18208089N3521KState Of North Carolina · Raleigh, NCBuilt 2002 · S/N 18280998N3521QCub Club Inc · Fort Myers, FLBuilt 2001 · S/N 172S8847N35229Coneburripul Corp · Miami, FLBuilt 2001 · S/N 172S8837N35230Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281017N3523RAviator Air Flight School LLC · Grand Prairie, TXBuilt 2001 · S/N 17281016N35246N35246 LLC · Stuart, FLBuilt 2001 · S/N 17281031N35249Baker Douglas · Rye, NHBuilt 2001 · S/N 17281030N3524FRegistered aircraftBuilt 2001 · S/N 18280975N3524LFlight Training Aircraft LLC · Wilmington, DEBuilt 2001 · S/N 172S8809N35253Liu Kaiyu · Metairie, LABuilt 2001 · S/N 172S8831N3525RCrabtree Jeremy Adam · Atlantic Beach, NCS/N 18280977N3525URandolph Macon Academy · Front Royal, VABuilt 2001 · S/N 172S8826N35261Walrath Aviation LLC · Tacoma, WABuilt 2001 · S/N T18208013N35265Turley Matthew Neil · Magnolia, TXS/N T18208014N3526JRainier Flight Service LLC · Renton, WAS/N 172S8829N3527ZLw Aviation LLC · Lewes, DEBuilt 2001 · S/N 172S8807N3528CAlvarez Fernando Perez · Santan Arecibo, PRS/N 18280959N3528DBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 18280960N35291Rochon Everette · Wesley Chapel, FLS/N 18280970N3529NOken Andrew · Corvallis, ORS/N 18280981N352AKKwartler Anatol · Maynard, MABuilt 2003 · S/N 172S9456N352AZFlight Feather LLC · Palo Alto, CABuilt 2023 · S/N T18209104N352CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281504N352MEFlying Start Aero Services LLC · Reno, NVBuilt 2000 · S/N 172S8587N352SPChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9499N3530JChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281010N3530ZWilliams Alan G · Sterling, VAS/N T18208023N35312Lam Raymond · Orlando, FLBuilt 2001 · S/N T18208015N35325Fly Cessna LLC · Peoria, AZS/N 172S8819N3532KHattell George Curtis · Olympia, WAS/N 18280974N3532TNs Aviation Training And Rental Inc · Pembroke Pines, FLS/N 172S8820N35339University Of Alaska Anchorage · Anchorage, AKS/N 172S8891
Back to AD 2005-05-53 R1