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.

N9202UOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281622 N920BWWilliams Rebecca J · Alto, NMBuilt 2001 · S/N 18280979 N920CFWingsleasing LLC · Wichita, KSBuilt 1997 · S/N 17280112 N920CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8341 N920EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12512 N920MTAcron Aviation Academy Inc · Sanford, FLBuilt 2006 · S/N 172S10214 N920TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2004 · S/N 17281206 N920WBJet Air Inc · Iowa City, IABuilt 2008 · S/N 172S10837 N921BBNorthwestern Michigan College · Traverse City, MIBuilt 2024 · S/N 172S13232 N921CTN921ct LLC · Elkton, KYS/N 18281220 N921EZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 172S8499 N921TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280244 N92228Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11498 N9222HDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11497 N9223CDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11499 N9223EDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11500 N9223XDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11501 N92264Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11502 N92266Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11503 N9229FCooke John W III · Carthage, TXBuilt 1997 · S/N 17280294 N922BCTanaka Akira · Torrance, CAS/N T18208121 N922CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8911 N922LHClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13554 N922MKNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282195 N922TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280249 N9230YDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11505 N923AZN923az LLC · Miami, FLBuilt 2025 · S/N 172S13280 N923CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 18283127 N923CTBragdon Emil · Fort Worth, TXS/N 172S8663 N923DBGrenville Andrew · Decatur Island, WABuilt 2002 · S/N 18281087 N923DMHt Holdings LLC · Oxford, MSBuilt 2004 · S/N 18281496 N923EDJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10624 N923EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13038 N923EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12979 N923GWCape Island Aviation LLC · Millville, NJBuilt 2002 · S/N 172S9023 N923JSSankey Aviation LLC · Warminster, PABuilt 2005 · S/N T18208390 N92417Heritage Bay LLC · Carmel, CABuilt 2012 · S/N T18209076 N9241BBorder Warehouse Inc · Mission, TXBuilt 2010 · S/N T18209008 N924AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13561 N924AZN924az LLC · Miami, FLBuilt 2025 · S/N 172S13282 N924CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8912 N924LPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2002 · S/N 172S9204 N9250VFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11182 N9254CFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11183 N9254YFlorida Memorial University Inc · Miami Gardens, FLBuilt 2012 · S/N 172S11192 N925CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8913 N925DBHawk2lane LLC · Newark, DEBuilt 2005 · S/N T18208366 N925EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13340 N925LLSutton-Gee Ryan · Lafayette, CABuilt 2025 · S/N T18209174 N925MHAir America Imagery LLC · Daytona Beach, FLBuilt 1999 · S/N 17280731

Back to AD 2005-05-53 R1