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.

N26139Textron Aviation Inc · Wichita, KSS/N 172S13625 N26140Textron Aviation Inc · Wichita, KSS/N 172S13628 N26143Textron Aviation Inc · Wichita, KSS/N 172S13631 N26145Textron Aviation Inc · Wichita, KSS/N 172S13634 N26146Textron Aviation Inc · Wichita, KSS/N 172S13637 N26148Textron Aviation Inc · Wichita, KSS/N 172S13640 N26149Textron Aviation Inc · Wichita, KSS/N 172S13643 N26150Textron Aviation Inc · Wichita, KSS/N 172S13646 N26153Textron Aviation Inc · Wichita, KSS/N 172S13649 N261AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281186 N261CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282136 N261EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13501 N261JBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12575 N261SCIndia Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13439 N2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1998 · S/N 17280559 N2625CL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280436 N262AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281187 N262CLGiga Energy Inc · Buna, TXBuilt 2004 · S/N 18281497 N262CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283017 N262MTBurns Mark R · Streetsboro, OHBuilt 2016 · S/N 18282449 N2630UShaka Skies LLC · Kihei, HIBuilt 1998 · S/N 17280568 N2632YAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280570 N2634EAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280572 N26379Wings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280573 N263EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13503 N263SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13406 N26481Accessible Aviation Inc · Tupelo, MSBuilt 1998 · S/N 17280578 N26499Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280730 N2649JN2649j LLC · Palm City, FLBuilt 1998 · S/N 17280599 N264EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13504 N264SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13407 N26502Bugsmasher Aviation LLC · Benton, KSBuilt 1998 · S/N 17280600 N26504Vista Aviation Inc · Pacoima, CABuilt 1998 · S/N 17280601 N2651RAtls Aviation LLC · Stuart, FLBuilt 1998 · S/N 17280542 N2656GAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280569 N265SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13409 N26630Iasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280565 N2663XAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280643 N266LARaintree Aviation LLC · Mesa, AZBuilt 2012 · S/N 172S11178 N266SPTfs Air LLC · Loveland, COBuilt 2003 · S/N 172S9471 N266TATextron Aviation Inc · Wichita, KSS/N 18283365 N267FGRidgeline Assets LLC · Wilmington, DES/N 172S12725 N267HPFlorida Highway Patrol · Tampa, FLBuilt 2002 · S/N 172S9267 N267RHPxw Services · Bristow, VABuilt 2010 · S/N 18282208 N2682CInternational Air Services Inc Trustee · Carson City, NVS/N 18281648 N268CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283018 N268CSInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 172S11266 N268CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281258 N268EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13506 N268FMRunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13268

Back to AD 2005-05-53 R1