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.

N711JSSterling Flight Training · Jacksonville, FLS/N 172S9682N711KFJ-Com Aviation LLC · Richland, MSBuilt 2001 · S/N 18280969N712EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12882N712LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 172S11659N712MSNational Aircraft Leasing · Greenville, DEBuilt 2009 · S/N 18282179N712NVEpic Aviation Enterprises LLC · Austin, TXBuilt 2005 · S/N 172S9960N712SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2000 · S/N 172S8640N713CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12529N713FSTfs Air LLC · Loveland, COBuilt 2008 · S/N 17281513N713LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 172S11660N713RBKay Timothy A · Kyle, TXBuilt 2000 · S/N 172S8547N713SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13579N713SZN713sz LLC · Jacksonville, FLBuilt 2023 · S/N 172S12957N713TRed Rock Airventures LLC · Moab, UTBuilt 2023 · S/N T18209111N7141CLongview Iron LLC · Longview, TXBuilt 2015 · S/N 18282375N7142RWirick Neil · Cable, OHS/N 18282454N714HWNational Training 1 LLC · Wilmington, DEBuilt 2005 · S/N 172S9855N714LULiberty University Inc · Lynchburg, VABuilt 2016 · S/N 172S11721N714SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12559N715BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280941N715CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281712N715DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2005 · S/N 18281734N715LULiberty University Inc · Lynchburg, VABuilt 2016 · S/N 172S11722N715MTSaz Dynamics LLC · Daly City, CABuilt 2008 · S/N 172S10873N715RCEide David B · Saint Michael, MNBuilt 2002 · S/N 18281085N715WMBgi Aircraft Management LLC · Alpharetta, GABuilt 2020 · S/N 172S12536N716CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281711N716EPEpic Flight Academy Inc · New Smyrna Beach, FLBuilt 2016 · S/N 172S11728N716HPState Of Ohio · Columbus, OHBuilt 2005 · S/N 18281581N716LULiberty University · Lynchburg, VABuilt 2012 · S/N 172S11180N716MCWing & A Prayer LLC · Wilmington, DEBuilt 2005 · S/N 18281717N716MTColvin Mariann · Round Rock, TXBuilt 2001 · S/N 18281037N716MWDirty Side Down Aviaton LLC · Georgetown, TXBuilt 2000 · S/N 17280871N716PCPcfo Air LLC · Plymouth, MNBuilt 2021 · S/N 18283159N716SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12557N716SPExec 1 Aviation II LLC · Ankeny, IABuilt 2000 · S/N 172S8645N716THFairmont State University · Fairmont, WVBuilt 2017 · S/N 172S12008N71755Jet Air Inc · Iowa City, IABuilt 1999 · S/N 17280800N717CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282250N717FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13456N717LULiberty University Inc · Lynchburg, VABuilt 2022 · S/N 172S12777N717THOhio State University · Columbus, OHBuilt 2017 · S/N 172S12009N718CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281713N718EHChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280061N718EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13022N718LULiberty University Inc · Lynchburg, VABuilt 2022 · S/N 172S12778N719CGAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13474N719CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281714N719LULiberty University Inc · Lynchburg, VABuilt 2023 · S/N 172S13072N719SRob Hance Management P C · Argyle, TXS/N 18283026
Back to AD 2005-05-53 R1