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.

N3533NHouck Rex S · Coxs Creek, KYBuilt 2001 · S/N T18208017N3533ULima 001 LLC · Muscatine, IAS/N 172S8890N3533WLongfellow Aviation Inc · Mequon, WIBuilt 2001 · S/N T18208029N3535PSchroder Urban · Fort Mitchell, KYS/N T18208020N35367Hinds Community College · Bolton, MSS/N 17281068N3536GGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2001 · S/N 17281048N35370Dans Land LLC · North Little Rock, ARBuilt 2001 · S/N T18208094N3537BDulles Aviation Inc · Bristow, VABuilt 2001 · S/N 172S8827N3537JAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11614N3537WPlane Fun Inc Tr Trustee · Snellville, GABuilt 2001 · S/N T18208093N35387Southeastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281100N35389Smith Martin P · Sedona, AZBuilt 2001 · S/N 172S8938N3538BWisman Craig B · Saint Augustine, FLS/N T18208068N3538LOne Seven Two Aviation Inc · Venice, FLBuilt 2001 · S/N 172S8953N353CPCivil Air Patrol · Montgomery, ALBuilt 2005 · S/N 18281505N353GSHorizon Flight Center LLC · Chesapeake, VABuilt 2019 · S/N 172S12280N353MEStratus Aviation LLC DBA · Vacaville, CABuilt 2000 · S/N 172S8588N353MVIgal Zubery · Los Angeles, CABuilt 2005 · S/N 172S9908N35408Elmendorf Aero Club · Jber, AKS/N 17281081N3540TAvcorp Holdings Inc · Jackson, MIBuilt 2001 · S/N 17281077N3541AFogle Douglas J · Valparaiso, INBuilt 2001 · S/N 18281048N3541FChandler Gregory E · St Albans, WVBuilt 2001 · S/N T18208078N3542BHuddleston James A · Eloy, AZBuilt 2003 · S/N 18281216N3542FJet Air Inc · Iowa City, IAS/N 17281075N3543GAmerican Aviation Inc · Brooksville, FLBuilt 2001 · S/N 17281079N3543HMagness Thomas W · West Chester, PABuilt 2002 · S/N 18281024N3544BAvcorp Holdings Inc · Jackson, MIBuilt 2001 · S/N 17281071N3544GMid-Island Air Service Inc · Ronkonkoma, NYS/N 17281072N3544WRapid Fleet I LLC · Carmel, INBuilt 2001 · S/N 172S8904N3544ZSky Chiefs Aviation LLC · Gainesville, FLS/N 172S8999N3545JBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281023N3546HOdonnell John Merritt · Kennebunkport, MEBuilt 2001 · S/N 18281017N3546QRahe John S · Marana, AZS/N 172S8889N3547FEastern Kentucky University · Richmond, KYS/N 172S8887N3547HCali Air LLC · San Ramon, CAS/N 172S8886N3547LSky Brothers LLC · Boulder, COS/N 172S8884N3547RL & R Flyers LLC · Bradenton, FLS/N 17281066N3548AKunard Kevin L · Pinedale, WYS/N T18208072N3548MSpenser Air LLC · Starkville, MSS/N 18281019N3548SSunny Skies Aviators LLC · Vernal, UTS/N 18281018N3548VT-28 LLC · Salem, ORBuilt 2001 · S/N 172S8892N35491L&W Leasing LLC · Smyrna, TNS/N 17281069N3549HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N T18208064N354CPCivil Air Patrol · Montgomery, ALBuilt 2005 · S/N 18281506N354CTCoast Flight Training And Management Inc · San Diego, CABuilt 2009 · S/N 172S10942N354ESN354es LLC · Stuart, FLBuilt 1997 · S/N 17280047N354TAChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9354N35502Sky Mates Inc · Wilmington, DES/N 172S8895N3550TTotal Flight Aircraft Leasing LLC · Apex, NCS/N 172S8893N3552CAtlas Aviation Tampa Inc · Tampa, FLBuilt 2001 · S/N 172S8900
Back to AD 2005-05-53 R1