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.

N882CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281862 N882EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13526 N882JDSanders Flight Training Center Inc · Jasper, ALBuilt 2025 · S/N 172S13325 N882JVBtl Consulting Inc · Vienna, ILBuilt 2006 · S/N T18208517 N882LAAircraft Holdings LLC · Mesa, AZBuilt 2020 · S/N 172S12608 N882LBArizona Flyers Club Inc · Tucson, AZBuilt 2001 · S/N 18280958 N882SATextron Aviation Inc · Wichita, KSS/N 172S13606 N882TCChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9880 N883CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282200 N883EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13529 N883KKLegacy Aviation LLC · Tigard, ORBuilt 2023 · S/N T18209127 N8845KVan Bortel Aircraft Inc · Arlington, TXBuilt 2012 · S/N 18282332 N884BCBusiness Mens Flying Club Inc · Naperville, ILBuilt 2007 · S/N 172S10545 N884CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282084 N884EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12808 N885EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12812 N885GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 2004 · S/N 172S9601 N886ABWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 17281516 N886CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 18283126 N886CTCoast Flight Training And Management Inc · San Diego, CABuilt 2006 · S/N 17281341 N886EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12813 N887CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281867 N887EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12817 N888DEWeyls Daniel Christopher · Medina, OHBuilt 2010 · S/N 18282228 N888LUFourth Stoop Flyers LLC · Manakin Sabot, VABuilt 2012 · S/N 172S11206 N888RYScrap Sales LLC · Manly, IABuilt 2025 · S/N T18209173 N889MWI S O Art Ltd · Hamilton, MTBuilt 2026 · S/N T18209198 N889SDMedary Aviation LLC · Brookings, SDBuilt 2025 · S/N 172S13322 N889SPLeading Edge Aviation Inc · Spencer, IABuilt 2002 · S/N 172S9088 N88HLLiberty Aero LLC · Carlsbad, NMS/N T18208377 N88JAGc Aviation Services-1 LLC · Miamisburg, OHBuilt 2001 · S/N 172S8776 N88NESorjen Inc · Indian Trail, NCBuilt 2023 · S/N 18283242 N88SQBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2021 · S/N 18283137 N89005Singh Fiyaad · Ocoee, FLBuilt 1997 · S/N 17280084 N890CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12635 N890EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13532 N890KCMustang Sally Aviation LLC · Camden, SCBuilt 2000 · S/N 17280890 N890MBVan Bortel Aircraft Inc · Arlington, TXBuilt 2013 · S/N 18282365 N891CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282411 N89225Lucky Dog Aviation LLC · Victoria, TXBuilt 2022 · S/N 18283169 N8925LLinton William A · Madison, WIBuilt 2007 · S/N T18208669 N892BVGd Aviation Inc · Belleair, FLBuilt 2004 · S/N 18281329 N892CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13059 N892EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12685 N893AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13539 N893CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281863 N894CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281864 N894EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13236 N894KCFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10742 N895AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13540

Back to AD 2005-05-53 R1