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.

N491SFSnohomish Flying Service Inc · Snohomish, WABuilt 2003 · S/N 172S9565N491SPLittle Rock Lsa Leasing And Rental LLC · Searcy, ARBuilt 1998 · S/N 172S8032N491WSDhs Operations LLC · Wilmington, DEBuilt 1999 · S/N 172S8305N4925QEsty Effew LLC · Wimberley, TXBuilt 2012 · S/N 18282326N492ERWings Over Kauai LLC · Kalaheo, HIS/N 172S8946N492SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8033N492TBTrux Aviation LLC · Wilmington, DEBuilt 2006 · S/N T18208505N493CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282265N493EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12260N493RMRaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280784N494EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11602N494JBD & S Aviation LLC · Spring, TXBuilt 2002 · S/N 172S9099N494SPInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N 172S8035N495EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12270N495JBVan Bortel Aircraft Inc · Arlington, TXBuilt 2004 · S/N T18208284N495MCC182t LLC · Chattanooga, TNBuilt 2007 · S/N 18281895N495SPFlying Start Aero Services LLC · Reno, NVBuilt 1998 · S/N 172S8036N495WWNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282170N496EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12271N496SPWingsleasing LLC · Wichita, KSBuilt 1998 · S/N 172S8037N496VBerkenkotter Transportation LLC · Howard, COBuilt 2006 · S/N T18208592N497ERPlane Three Ltd · Wilmington, DEBuilt 1998 · S/N 17280673N497SJFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2000 · S/N 172S8497N497TCPinnacle Aviation Services Inc · Encinitas, CABuilt 2005 · S/N 172S9870N498EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11603N498SPBmg Aviation Inc · Bloomington, INBuilt 1998 · S/N 172S8039N499CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12510N499DRWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 172S9167N499EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11604N499ETQualitair LLC Owner Trustee · MichesltadtBuilt 2006 · S/N 18281808N499KWRidgeline Assets LLC · Wilmington, DEBuilt 2000 · S/N 172S8430N49RHChristiansen Aviation LLC · Wilmington, DES/N 172S12932N4QPN4qp LLC · Union Gap, WABuilt 2020 · S/N 172S12429N4RGMayer Gordon · Dallas, TXBuilt 2002 · S/N 18281086N5000YSutter Street Holdings LLC · Santa Monica, CABuilt 2008 · S/N 172S10868N50011Taco George Aviation LLC · Coppell, TXBuilt 2008 · S/N 172S10865N5001UOew Aviation LLC · Sumter, SCBuilt 2001 · S/N 172S8959N5004YElon Aviation LLC · Burlington, NCBuilt 2001 · S/N 172S8961N500BWRaw Inc · Raleigh, NCBuilt 2017 · S/N 18283015N500GPEhg Flight LLC · Venice, CABuilt 1998 · S/N 17280500N5011UAtp Aircraft 2 LLC · Wilmington, DEBuilt 2008 · S/N 172S10881N5015HKnox Fred · Los Altos, CABuilt 2001 · S/N T18208096N501ERVista Air Inc · Pacoima, CABuilt 2001 · S/N 172S8947N501SCSaz Dynamics LLC · Daly City, CABuilt 2005 · S/N 172S9883N5020ABrown Jonathan Corey · Sherman Oaks, CABuilt 2001 · S/N T18208097N5023JTexas State Technical College · Waco, TXBuilt 2001 · S/N 172S8964N502ERZoeing Lease Inc · Lewes, DEBuilt 1998 · S/N 172S8002N5030BInternational Air Services Inc Trustee · Carson City, NVBuilt 2009 · S/N 172S10887N5033TJulol Investments LLC · Miami, FLBuilt 2005 · S/N T18208454N5035MFlight World Inc · San Juan, PRBuilt 2001 · S/N 172S8967
Back to AD 2005-05-53 R1