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.

N408ESRussell Robert Q · Genoa City, WIBuilt 1997 · S/N 17280226 N408LBM & G Aircraft Management LLC · Englewood, COBuilt 2012 · S/N 172S11157 N4097MN4097m LLC · Boynton Beach, FLBuilt 1998 · S/N 17280322 N409CQPaper Airplane Co LLC · Broomfield, COBuilt 2018 · S/N 18283041 N409CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11440 N409CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282443 N409ESN409es LLC · Stuart, FLBuilt 1997 · S/N 17280231 N409LPSolberg Aviation Co Inc · Whitehouse Station, NJS/N 172S9409 N40RFGamma Flight LLC · Reno, NVBuilt 2007 · S/N 172S10473 N410BSCorestrength LLC · San Francisco, CABuilt 2005 · S/N 172S9966 N410CRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11441 N410CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282447 N410KCTerrapin Station Air LLC · Spokane, WABuilt 2007 · S/N 18282012 N410LRWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280257 N410MTAcron Aviation Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10426 N410WDN410wd LLC · Dallas, TXBuilt 2025 · S/N 18283299 N411CPX-Ray Lima Aviation LLC · Fort Lauderdale, FLBuilt 2010 · S/N 18282232 N411DRParkway Investments LLC · Rexburg, IDBuilt 2007 · S/N T18208713 N411ESAttitude Aviation Inc · Livermore, CABuilt 1997 · S/N 17280223 N411LPPlan A Ltd · Middletown, DEBuilt 2002 · S/N 18281114 N412BWGms Storage Solutions LLC · Lake Oswego, ORBuilt 2005 · S/N T18208476 N412FBLunken Flight Training Center LLC · Cincinnati, OHBuilt 2017 · S/N 172S12043 N412FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11443 N412SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8322 N412SSConnelly James · Spearman, TXBuilt 2022 · S/N 18283196 N412WMBroadwell Group Inc · Alpharetta, GABuilt 2012 · S/N 172S11175 N413AAAmerican Aviation Inc · Brooksville, FLBuilt 2000 · S/N 172S8413 N413CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13239 N413CSGolf Romeo Charlie LLC · Elk Grove, CABuilt 2016 · S/N 18282413 N413EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12640 N413ESAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280218 N413MFRegistered aircraftBuilt 2015 · S/N 18282412 N413RDDos Amigos Air Service LLC · Carrizo Springs, TXBuilt 2004 · S/N 18281464 N413TCMcbeath Casey A · Shreveport, LABuilt 2005 · S/N T18208423 N414CHZeliff Aviation LLC · Batavia, NYBuilt 2025 · S/N T18209181 N414ERRegistration Pending · Wilmington, DERegistration pendingBuilt 2017 · S/N 172S12026 N414PKTakeoff Properties LLC · Belmont, NCBuilt 2023 · S/N 18283243 N414TBTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13494 N415RJAviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S9943 N415SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8346 N416CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12504 N416CSTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N 18282416 N416FRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11444 N416SPRegistered aircraftBuilt 2000 · S/N 172S8349 N416WREagle Flying Club Of Embry-Riddle Aero Univ Inc · Daytona Beach, FLBuilt 2002 · S/N 172S9160 N4172PDmac Aircraft LLC · Savannah, GABuilt 1997 · S/N 17280288 N417CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283025 N417DDSc Flyers Inc · Wilmington, DEBuilt 2002 · S/N 18281169 N417ERBrunner Aerospace LLC · Georgetown, TXBuilt 2014 · S/N 172S11445 N418DMMria LLC · Phoenix, AZBuilt 2015 · S/N 18282418

Back to AD 2005-05-53 R1