Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,036

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.

N2381ZLeone Brighter Developments LLC · Carlsbad, CABuilt 2005 · S/N 17281276 N2382RTampa Bay Aviation Inc · Clearwater, FLBuilt 1999 · S/N 17280700 N2383GChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280701 N23841Lam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 17280710 N2384LChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280706 N2384UMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280708 N2385FAlpha Aviation Inc · Mount Vernon, WAS/N 17280714 N2386VEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 17280702 N2387UChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280721 N2389VMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280729 N238ABTextron Aviation Inc · Wichita, KSS/N 172S13626 N238CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283016 N238CSD H Hutson Enterprises Inc · Waxhaw, NCBuilt 2011 · S/N T18209038 N238MChe Brothers LLC · Winters, CABuilt 2008 · S/N T18208843 N238SPEdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8223 N238THLewis University · Romeoville, ILBuilt 2018 · S/N 172S12140 N2390CIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280789 N2391MClover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281171 N2393ZSky Training LLC · West Milford, NJBuilt 2000 · S/N 172S8596 N23959State Of Wisconsin · Madison, WIBuilt 2006 · S/N 18281748 N2396KWhitley Pat · Altoona, ALBuilt 2006 · S/N 18281750 N239FGRidgeline Assets LLC · Wilmington, DEBuilt 2024 · S/N 172S13273 N239KStick Ball Rudder LLC · Bonita Springs, FLBuilt 2022 · S/N 172S12829 N239PD&J Training Planes LLC · Logan, UTBuilt 2004 · S/N 172S9613 N239SPAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 172S8224 N239TATextron Aviation Inc · Wichita, KSS/N 172S13613 N23EFRapid Flyers LLC · Zionsville, INBuilt 2004 · S/N 172S9669 N23KRUniversity Of Central Missouri · Warrensburg, MOBuilt 2023 · S/N 172S12952 N23NPAia Foxtrot LLC · Henderson, NVBuilt 2023 · S/N 172S12984 N23SKPlainsman Aviation LLC · Kalispell, MTBuilt 2023 · S/N T18209129 N23TLLottman Aviation LLC · Beatrice, NEBuilt 2004 · S/N 18281503 N23VGPainted Horse Holding LLC · New Town, NDBuilt 2013 · S/N T18209099 N23YPBmf Jax LLC · Jacksonville, FLS/N 18281468 N23YRP R Parker Company Inc · Shreveport, LABuilt 2015 · S/N 18282379 N2401AWhite Pat J · Wellington, TXBuilt 2006 · S/N 18281755 N2405SJohn L Lyle Aviation LLC · Ridgeland, MSBuilt 2006 · S/N 18281759 N2407NPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10550 N2409ENutac Leasing LLC · Deland, FLBuilt 2007 · S/N 172S10552 N240CSSem Assets LLC · Carrollton, TXBuilt 2024 · S/N T18209140 N240CTCoast Flight Training & Management Inc · San Diego, CABuilt 2006 · S/N 17281352 N240DCWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281099 N24108Svetfur Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10504 N24129Ssi Aviation Group LLC · Eagle, IDBuilt 2007 · S/N T18208756 N2412WWestern Edge Aviation LLC · Dickinson, NDBuilt 2007 · S/N 172S10557 N2413M2021 Liberty Air LLC · Santa Rosa, CAS/N T18208758 N24144Edb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10558 N241ABTextron Aviation Inc · Wichita, KSS/N 172S13627 N241AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281182 N241EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2024 · S/N 172S13238 N241JJN241jj LLC · Louisville, KYBuilt 2025 · S/N 18283313

Back to AD 2005-05-53 R1