Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N6161PTse Jeffrey R · Boulder, COBuilt 2005 · S/N T18208384 N6162VAir Ventures Hawaii LLC · Lihue, HIBuilt 2004 · S/N 18281373 N6162ZHolloman Afb Aero Club · Holloman Afb, NMBuilt 2004 · S/N 18281375 N6165ZNewman Construction Inc DBA · Riverton, UTBuilt 2008 · S/N T18208809 N6166QSteven K Jonas Pa · New Port Richey, FLBuilt 2008 · S/N T18208808 N6167KDuncan Marianna G · Lufkin, TXBuilt 2004 · S/N 18281379 N6167LEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2004 · S/N 18281380 N616CPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283352 N616FKenzy 2020 LLC · Aurora, ORBuilt 2020 · S/N 172S12516 N616MCFletcher Flying LLC · Russellville, ARS/N 18281616 N616RETunnell Shane Michael · Heber, AZBuilt 2007 · S/N T18208772 N6173QKinder Mark Edward · Bozeman, MTBuilt 2004 · S/N 18281388 N6175UDsd Air LLC · Ft Wright, KYBuilt 2008 · S/N T18208816 N617DSLets Fly Away LLC · Cincinnati, OHBuilt 2024 · S/N T18209139 N617EPEpic Aviation Inc DBA · New Smyrna Beach, FLBuilt 2017 · S/N 172S12042 N617EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12717 N617FGRidgeline Assets LLC · Wilmington, DEBuilt 2020 · S/N 172S12597 N617SPPrecision Design Inc · Wilmington, DEBuilt 2000 · S/N 172S8606 N617TWTango Whiskey Aviation LLC · Cody, WYBuilt 2002 · S/N 18281176 N61808Cape Island Aviation LLC · Millville, NJBuilt 2008 · S/N 172S10709 N6180TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12389 N6180WChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10706 N6180XLewis University · Romeoville, ILBuilt 2008 · S/N 172S10707 N6182FAllsouth Aviation LLC · Buford, GABuilt 2008 · S/N 18282079 N6182UEfi Aviation LLC · Wilmington, DEBuilt 2008 · S/N 18282080 N6182ZDillman Robert C · Lake Geneva, WIBuilt 2008 · S/N T18208839 N6183GFly Time LLC · Merrill, ORBuilt 2008 · S/N T18208844 N6183SFarm Air LLC · Gridley, CABuilt 2004 · S/N 18281389 N6185UMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10719 N6186TAtlas Aviation Tampa Inc · Tampa, FLBuilt 2008 · S/N 172S10729 N6186VFloriflt LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10730 N6187JSky King Farmer LLC · Bentleyville, PABuilt 2008 · S/N 18282094 N6187LH-Cel Aviation LLC · Alanson, MIBuilt 2008 · S/N T18208855 N6187XLakeside Aviation LLC · Kalispell, MTBuilt 2008 · S/N T18208857 N6189QParamus Flying Club Inc · Fairfield, NJBuilt 2008 · S/N 172S10738 N618DHCorsair Aviation LLC · Pacoima, CABuilt 2012 · S/N 172S11186 N618EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2018 · S/N 172S12164 N618FFette Ian C · Coeur D Alene, IDBuilt 2011 · S/N T18209021 N618JMSkyknight LLC · Greeneville, TNBuilt 2012 · S/N 172S11164 N618LRNiyol Aviation LLC · Irving, TXBuilt 2008 · S/N T18208829 N618VCRaevin Aviation LLC · Bellmore, NYBuilt 2004 · S/N 172S9716 N61904Triple H Flying LLC · Springfield, MABuilt 2008 · S/N T18208858 N61907Lisella Glen J · Las Vegas, NVBuilt 2008 · S/N T18208861 N6190CChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10741 N6191APearson Aero Solutions LLC · Dallas, GABuilt 2008 · S/N T18208862 N6193CAirspeed Mammography Certifications LLC · Olympia, WABuilt 2008 · S/N 18282072 N6193DDe Anza Building And Maintenance Inc · Los Altos, CAS/N 18281394 N6193MFreiesleben Thomas K · Brookfield, WIBuilt 2008 · S/N 18282058 N6193RAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 18282061 N61942Middle Village Enterprises LLC · Maspeth, NYBuilt 2008 · S/N 172S10772

Back to AD 2005-05-53 R1