Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,034

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.

N1766TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12110 N176BLChristiansen Aviation LLC · Wilmington, DEBuilt 2013 · S/N 172S11287 N176MEEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 172S8470 N176TAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2018 · S/N 172S12115 N1774TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12111 N177CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282338 N177VZCollinair LLC · Coppell, TXBuilt 2011 · S/N T18209024 N1781TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12112 N1782TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12113 N1788TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12114 N178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2003 · S/N 17281177 N178CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13039 N178GWBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12491 N178JMDcd Aviation LLC · Heber, CABuilt 2006 · S/N T18208534 N179CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282339 N179JSMcdonald Timothy Steven · Slaton, TXBuilt 2004 · S/N 18281481 N179VBAdl Tracey LLC · Warrenton, VABuilt 2013 · S/N T18209079 N17BMNavigation Leasing LLC · Castle Rock, COBuilt 2023 · S/N 172S12978 N17GMNorthwestern Michigan College · Traverse City, MIBuilt 2021 · S/N 172S12769 N17HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2004 · S/N 18281436 N17MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12598 N17SJAnson Air LLC · Sugar Land, TXBuilt 1999 · S/N 172S8344 N17YRNagle Jeffrey · Fremont, INS/N 18282456 N1806MCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13177 N180BWJ&B Flight Service LLC · Brownsville, TXBuilt 2006 · S/N T18208552 N180CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12727 N180SUOhio State University · Columbus, OHBuilt 2018 · S/N 172S12161 N1810SSwift Current Resources LLC · Billings, MTS/N T18208433 N1812EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12168 N1815UJanson James A · Eagle, IDBuilt 2005 · S/N T18208434 N1817EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12169 N181CSElkhorn Valley Trucks II LLC · Fremont, NEBuilt 2024 · S/N 18283280 N181GSTravel Services LLC · Metropolis, ILBuilt 2006 · S/N T18208499 N181LBWatts Rodney · Hot Springs, SDBuilt 2006 · S/N T18208666 N181MWCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1997 · S/N 17280181 N181SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2016 · S/N 172S11663 N181TWTom Wood Aviation Inc · Fishers, INBuilt 2026 · S/N 172S13549 N1820EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12170 N1821ZTubbs George L · Colby, KSBuilt 2005 · S/N T18208435 N1823EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12171 N1825EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12172 N1827AShmily Aviation LLC · Tampa, FLBuilt 2005 · S/N 18281615 N18282House John R · Roseville, CABuilt 2024 · S/N T18209136 N1828EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12173 N182AHShelby Ronnie F · Comanche, OKBuilt 2011 · S/N T18209037 N182AXN182ax LLC · Newark, DEBuilt 2002 · S/N 18281072 N182BGSuburban Air Corp · Castro Valley, CAS/N 18281536 N182DPCopeland Aviation LLC · Cedar Park, TXBuilt 2002 · S/N 18281124 N182DUAlba Alfonso Jose Munk · Key Biscayne, FLS/N T18208374 N182EHHolland Max Eugene · Nebo, NCBuilt 2025 · S/N 18283332

Back to AD 2005-05-53 R1