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.

N418ESWright Aero Inc · Saint Cloud, MNBuilt 1998 · S/N 17280358N4190PChaleff George S · Johnson, VTBuilt 1998 · S/N 17280620N4190VAtp Aircraft 2 LLC · Wilmington, DEBuilt 1998 · S/N 17280626N41912Eastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280628N4193RHunter Jeffrey Jay · Shreveport, LABuilt 1998 · S/N 17280636N419CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12348N419CSGarza Richard · Monterey, CABuilt 2016 · S/N 18282419N419EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12278N419FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11446N419JARaw Aviation LLC · Wichita, KSBuilt 2007 · S/N 18281885N41DLLdair Inc · Roanoke, VABuilt 2002 · S/N 18281142N42007Southeastern Oklahoma State University · Durant, OKBuilt 1999 · S/N 17280744N4202LAa-Aero LLC · Fairfield, NJBuilt 1999 · S/N 17280747N4203PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 17280748N420CSSugar Lips Aviation LLC · Kalispell, MTBuilt 2005 · S/N 18281650N420ERAtp Aircraft 2 LLC · Wilmington, DEBuilt 1998 · S/N 17280634N420FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281494N420HPBraden Health LLC · Greensboro, NCBuilt 2005 · S/N 18281637N420SPWings Over Texas Holdings LLC · Denton, TXBuilt 2000 · S/N 172S8351N420URcs Services LLC · California, MDBuilt 1997 · S/N 17280120N420WABlue Yonder Enterprises LLC · Los Altos, CABuilt 2017 · S/N 18283027N421CSCrowbar Enterprises LLC · Inola, OKBuilt 2021 · S/N 18283121N421ERCc Aviation Inc · Tracy, CABuilt 2004 · S/N 172S9679N421FPJustus Christopher S · Corona, CABuilt 1998 · S/N 17280638N421FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281495N421KRAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N T18208308N421RWPac1 LLC · Clinton, IABuilt 2004 · S/N 172S9593N421SARedbreast Aviation LLC · Boonton, NJBuilt 2004 · S/N 18281378N422CBHeavy Metal Air LLC · Farmingdale, NYBuilt 2005 · S/N 172S10011N422EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2017 · S/N 172S12022N422HABrightwater Enterprises LLC · Lakeway, TXBuilt 2005 · S/N 172S9830N422LSSkyknight LLC · Greeneville, TNBuilt 2011 · S/N 172S11117N422MTMissouri Dept Of Transportation · Jefferson City, MOBuilt 2008 · S/N 18282051N422SHSig Aero LLC · Lewes, DEBuilt 2019 · S/N 18283090N4231TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12370N423CAAerochatt LLC · Cleveland, TNBuilt 2015 · S/N 172S11612N423EWings Over Texas Holdings LLC · Denton, TXBuilt 2014 · S/N 172S11447N423SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12542N423SPSierra Papa LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8352N423TABas Part Sales LLC · Greeley, COBuilt 2003 · S/N T18208208N424DN424d LLC · Naples, FLBuilt 2024 · S/N T18209162N424EChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11448N424EKDeland Air And Sea Brokerage Inc · Deland, FLBuilt 2009 · S/N T18208981N424PEUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2017 · S/N 172S12058N424STMisto Louis III · Westerly, RIBuilt 2005 · S/N 18281739N424TRCovin Equipment LLC · Arlington, TXBuilt 2005 · S/N 18281562N424WHSchmidt Richard A · West Linn, ORBuilt 2004 · S/N T18208294N4258FGoldfinch LLC · New York, NYBuilt 2024 · S/N T18209135N425CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8687N425CRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11449
Back to AD 2005-05-53 R1