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.

N445BWFlight Operations Aircraft LLC · Wilmington, DES/N 17280662 N445CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13248 N445CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282356 N445DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8264 N445KSPeraton Services LLC · Bozeman, MTBuilt 2020 · S/N 172S12534 N446AFBeale Air Force Base Aero Club · Beale Afb, CABuilt 1998 · S/N 17280446 N446CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13263 N446CSSocal Pilot Center · La Quinta, CABuilt 2017 · S/N 172S12001 N446ERWingsleasing LLC · Wichita, KSBuilt 2006 · S/N 172S10220 N446SPLam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 172S8310 N447CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282353 N447ERSilver Express DBA · Miami, FLS/N 172S10221 N448AFBeale Air Force Base Aero Club · Beale Afb, CABuilt 1998 · S/N 17280448 N448CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12505 N448ERAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280610 N448RJRonald Janis · New York, NYBuilt 2019 · S/N 18283081 N449CSHorizon Flight Center LLC · Chesapeake, VABuilt 2017 · S/N 172S12025 N449SPGolden Eagle Flying Club Ltd · West Islip, NYBuilt 1999 · S/N 172S8315 N44PYSegler Angela U · Marco Island, FLBuilt 2000 · S/N 172S8543 N44UDB & K Aviation LLC · Danville, CABuilt 2017 · S/N 172S12072 N44WSAviation Insurance Managers Inc · Uniontown, OHBuilt 2023 · S/N T18209108 N450EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12955 N451BA1928 LLC · Salmon, IDBuilt 2005 · S/N 18281645 N451CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282194 N452CPCivil Air Patrol · Montgomery, ALBuilt 2013 · S/N 18282368 N452EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11586 N452KKramarich Kenneth · Wintersville, OHBuilt 2024 · S/N 18283284 N452PDBpd Enterprises LLC · Ponte Vedra Beach, FLBuilt 2004 · S/N T18208282 N452SMChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10528 N453CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280845 N453EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12645 N453SPUnited States Air Force Owner · Elmendorf Afb, AKBuilt 1999 · S/N 172S8297 N454AGAb Prop Plane II LLC · Metairie, LABuilt 2015 · S/N 172S11588 N454CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280846 N455CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282196 N455EPDove Aviation 455ep LLC · Stuart, FLBuilt 1998 · S/N 17280664 N455HSSagnieres Hubert · Newport, VTBuilt 2001 · S/N 18281054 N456CSZhang Li · Palo Alto, CABuilt 2016 · S/N 18282451 N456CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282445 N456DXAviolease LLC · Vancouver, WABuilt 2005 · S/N 172S9871 N456ERSoaring 2 Success LLC · Cary, ILBuilt 1998 · S/N 17280667 N456MBDhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280033 N456SPAc Aviation LLC · Ocklawaha, FLBuilt 1999 · S/N 172S8320 N4577Gateway Of Sturgis LLC · Sturgis, MIBuilt 1999 · S/N 172S8285 N457CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280849 N457EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11593 N457SPSouth Dakota State University · Brookings, SDBuilt 1999 · S/N 172S8321 N458CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 172S13267 N458CDDiacont Charles R · Nazareth, PABuilt 2003 · S/N 18281231 N458CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280850

Back to AD 2005-05-53 R1