OpenAirDocs.org
AD 2005-05-53 R1

Registered aircraft · 6,036

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.

N22055Adrian Ojeda Jr · San Ysidro, CAS/N 17280902N2209HLynxaviation LLC · Carpinteria, CABuilt 2007 · S/N T18208672N220CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13256N220CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13046N220CSTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2023 · S/N 18283220N220WCJeffery & Weiss Holdings LLC · Long Beach, CAS/N 172S10519N2214LBlue Bird Aviation LLC · San Jose, CABuilt 2005 · S/N 18281718N2217LInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 18281674N221EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12621N221GSBarientos Bryan I · Petaluma, CABuilt 2001 · S/N T18208034N221MEKarabin Gerald D · Vicksburg, MIBuilt 2000 · S/N 172S8481N2220YFarid Zia Physical Therapist A Professional Corp · El Centro, CABuilt 2005 · S/N 18281676N2221RPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1998 · S/N 17280681N2221XK C Leasing Corp · Woods Cross, UTBuilt 2007 · S/N T18208703N22237Aviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S10025N2223UDylans Rv Center LLC · Waterford, NJBuilt 2005 · S/N 18281677N2225AFreedom Aviation Inc · Lynchburg, VABuilt 2007 · S/N 172S10467N2225FTextron Aviation Inc · Wichita, KSBuilt 2007 · S/N 172S10468N22265Edb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S10026N2227FBay Area Aviation LLC · Beach City, TXBuilt 2005 · S/N 18281681N2228THulsey Hunter · Madison, MSBuilt 2005 · S/N T18208480N222DCTextron Aviation Inc · Wichita, KSS/N 18283364N222KWHines Tommy · Calvert City, KYBuilt 2007 · S/N T18208759N222LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8919N2231EState Of Iowa · Des Moines, IABuilt 2007 · S/N 18281924N2231FSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 18281925N2234UMountain States Casing Co LLC · Timnath, COBuilt 2006 · S/N T18208485N2235VE & R Aviation Services Inc · Long Beach, CAFirst renewal noticeBuilt 2007 · S/N 172S10478N22373Roche Timothy P · Falls Church, VABuilt 2007 · S/N 18281928N2237SOregon State Police · Salem, ORBuilt 2006 · S/N T18208488N223APJuliet Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13440N223BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280950N223CKBounds Keith A · Thomson, GABuilt 2004 · S/N 172S9580N223EMKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282252N223HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 17281112N223JMEid Bradley · Greenwood, INBuilt 2006 · S/N T18208484N223LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9223N2241VEdwards John D · Yardley, PABuilt 2007 · S/N 172S10481N2244WTextron Aviation Inc · Wichita, KSBuilt 2007 · S/N T18208714N22467Mustang Sally Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10487N2247TYellow Jacket Flying Club Inc · Atlanta, GABuilt 2007 · S/N 18281934N224EMFsm Aviation LLC · Edmond, OKS/N 18281350N224MAAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8613N224TFCdtskyview LLC · Medford, ORBuilt 2008 · S/N T18208906N224VSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12893N2252ZBerman Rayanne S · Hatfield, PABuilt 2006 · S/N T18208490N2254URaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280684N2258ZPope Charles A · Sandy Hook, MSBuilt 2007 · S/N 18281937N22593State Of Nc · Raleigh, NCS/N 18281938N225EAArellano Erick · Brownsville, TXBuilt 2024 · S/N 18283273
Back to AD 2005-05-53 R1