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.

N126HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9053 N126KMHessel Aviation LLC · Wilmington, DEBuilt 2007 · S/N T18208701 N126MEGlobal Flight Training Solutions Inc · Immokalee, FLS/N 172S8378 N126SPPilling Stephen · Southport, NCBuilt 2005 · S/N 172S9796 N1270KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13057 N1274VDiamond Specialized Inc · Richmond, OHBuilt 2008 · S/N T18208807 N1277WRush Aviation Rentals Inc · Meridian, IDBuilt 2001 · S/N 172S8846 N127CFGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18282027 N127HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2003 · S/N 172S9532 N127KWElizabeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9827 N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256 N1280KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13064 N1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2006 · S/N 172S10333 N1287ECrown Coast LLC · Costa Mesa, CABuilt 2006 · S/N 172S10335 N1289YBravo Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9851 N128SCIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8250 N128SHCalifornia In Nice Inc DBA · San Jose, CABuilt 2020 · S/N 172S12457 N1290FKilm LLC · Wilmington, NCBuilt 2007 · S/N 18282045 N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353 N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9667 N129JAWhite River Holdings LLC · Hernando, MSBuilt 2022 · S/N 18283172 N129JTNiles Air LLC · Concord, NCBuilt 2024 · S/N 18283288 N129KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12825 N129SWRoyal Air LLC · Sarasota, FLBuilt 2018 · S/N 172S12210 N129WSNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S10012 N12HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281158 N1305BTriangle Aviators LLC · Cary, NCBuilt 2007 · S/N 172S10654 N1306CWateractive43 LLC · Auburn, CABuilt 2007 · S/N 172S10655 N1306MFreedom Aviation Inc · Lynchburg, VABuilt 2006 · S/N 172S10336 N1307CHouse Of Raeford Farms Inc · Rose Hill, NCBuilt 2006 · S/N 172S10337 N1309GPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10342 N1309MReny Donald Cyril Jr · League City, TXBuilt 2008 · S/N 18282050 N130JAHagele Aviation LLC · Hillsboro, ORBuilt 2002 · S/N 172S9165 N13151F N A Aviation LLC · Wakefield, MABuilt 2006 · S/N 172S10344 N1315BN1315b Aviation LLC · Wilmington, DEBuilt 2002 · S/N T18208147 N1318QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10657 N131AZSuraair Holdings Inc · Wilmington, DEBuilt 2012 · S/N 172S11165 N131DLFlyaway Inc · Fort Worth, TXBuilt 2007 · S/N T18208717 N1322KCleared Into Bravo LLC · Sunnyvale, CABuilt 2006 · S/N 172S10345 N1322YAlcyone Trust Corp Trustee · Wichita, KSBuilt 2008 · S/N T18208811 N1322ZInternational Realty Group LLC · Bakersfield, CABuilt 2024 · S/N T18209134 N1323KFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10348 N1323NJohnston Jeffrey Heath · Midland, TXBuilt 2006 · S/N T18208665 N1323XMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10367 N13259Nuthatch Air Services LLC · New York, NYBuilt 2006 · S/N T18208663 N1325DMontero Carlos · San Lorenzo, CABuilt 2006 · S/N T18208658 N1325YDuty First Holdings LLC · Wichita, KSBuilt 2006 · S/N T18208660 N1327NGulf Coast Aviation LLC · New Orleans, LABuilt 2006 · S/N 172S10380 N1327ZN1327z LLC · Palm City, FLBuilt 2005 · S/N 172S9867 N1328NFirst Agri Inc · Sudan, TXBuilt 2005 · S/N T18208403

Back to AD 2005-05-53 R1