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.

N372BHLewis University · Romeoville, ILBuilt 2006 · S/N 172S10110 N372CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282002 N372HBUnited States Air Force 21 Force Support Squadron · Colorado Springs, COBuilt 2005 · S/N 172S9983 N372TADap Aviation LLC · Reston, VABuilt 2006 · S/N 172S10372 N372TWTom Wood Aviation · Fishers, INBuilt 2015 · S/N 172S11632 N373CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281986 N373SAValiair Lc Trustee · Casper, WYBuilt 2019 · S/N 18283087 N373WDBeardall Ann · Kiowa, COBuilt 2004 · S/N T18208264 N3744YKt 2022 LLC · Broomfield, COBuilt 2020 · S/N 172S12435 N374CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281987 N374MASeatown Air LLC · Seattle, WABuilt 1999 · S/N 172S8076 N374SAFloris Flight Services LLC · Midland, TXBuilt 2013 · S/N 172S11274 N374SPSkiles Richard L · Wimberley, TXBuilt 2003 · S/N 172S9503 N375MASteinhardt Clark R Jr · Green Bay, WIBuilt 1999 · S/N 172S8077 N376SPTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2003 · S/N 172S9508 N3776TFractional Villas Inc · Del Mar, CABuilt 2004 · S/N T18208314 N377CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283308 N377ESEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1997 · S/N 17280086 N378CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13260 N378MARussell Robert Q · Genoa City, WIBuilt 1999 · S/N 172S8078 N378MSJulius Kaleb · Tucson, AZBuilt 2002 · S/N T18208082 N379BFDay Darrell Rodney · Sahuarita, AZBuilt 2004 · S/N T18208253 N379GPGreat Pacific Aviation Services Inc · Grants Pass, ORBuilt 2005 · S/N T18208379 N379SAAerofeather Aviation Inc · Suffolk, VABuilt 2002 · S/N T18208074 N379TAChuck Smith Aircraft Inc · Torrance, CABuilt 2003 · S/N 172S9379 N37CJFly172s LLC · Peoria, AZBuilt 1999 · S/N 172S8232 N37HDJohnston-Matejek Aviation LLC · Houston, TXBuilt 2006 · S/N 18281850 N37JAFlying Start Aero Services LLC · Reno, NVBuilt 1997 · S/N 17280095 N37MTBeaver Valley Flying Club Inc · Beaver Falls, PABuilt 1999 · S/N 172S8205 N37SDAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13250 N37SEPacific Northwest Aircraft Leasing Inc · Meridian, IDBuilt 2001 · S/N 17281035 N380CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282459 N380MEVpc Air Inc · Cartersville, GABuilt 2000 · S/N 172S8559 N381CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12139 N381ESFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1997 · S/N 17280081 N382AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281192 N382CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282461 N382JSDap Aviation Ventures LLC · Missoula, MTBuilt 2021 · S/N 18283156 N383DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12648 N383KDT-6 LLC · Wilmington, DEBuilt 2012 · S/N 18282358 N383MEParlu Ventures LLC · Eagles Mere, PABuilt 2000 · S/N 172S8567 N383SPKv Helicopters LLC · Lititz, PABuilt 1999 · S/N 172S8279 N383TCSpengler Raymond Francis Jr · Longview, TXBuilt 2003 · S/N 172S9383 N384EAMatisoff Noah · Helena, MTBuilt 2008 · S/N T18208884 N384JVan Bortel Aircraft Inc · Arlington, TXBuilt 2025 · S/N T18209175 N384MCAero-Tech Services Inc · Lancaster, PABuilt 2007 · S/N 172S10438 N384MESj Flyers LLC · San Jose, CABuilt 2000 · S/N 172S8569 N3852BGromley Kevin M · Farmington, MIBuilt 2011 · S/N T18209028 N385DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12651 N385KLIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8116

Back to AD 2005-05-53 R1