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.

N172SJCommonwealth Of Massachusetts · Bridgewater, MABuilt 1997 · S/N 17280291 N172STTextron Aviation Inc · Wichita, KSS/N 172S13635 N172TGMaya Air Services LLC · Lee, NHBuilt 2002 · S/N 172S9126 N172TQAvolant Aviation LLC · Mooresville, NCBuilt 1998 · S/N 17280391 N172WFStick & Rudder Club Inc · Waukegan, ILBuilt 1999 · S/N 172S8167 N172WGWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17281018 N172WYCrosshares Aircraft Holdings LLC · Plymouth, INBuilt 1998 · S/N 17280334 N172ZFWangsness Jeff John · Ankeny, IAS/N 172S8451 N17304Phoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10643 N1730SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12281 N1731SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12282 N1732ARegistration Pending · Farragut, TNRegistration pendingBuilt 2007 · S/N 18282032 N1732LJohnson Ralph R Jr · Roanoke Rapids, NCBuilt 2007 · S/N 18282033 N1732SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12283 N1733SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12284 N1734SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12285 N1735XAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10648 N1737LZdad Aviation LLC · Little Rock, ARBuilt 2007 · S/N 18282038 N1738CScc Aviation LLC · Caldwell, TXBuilt 2007 · S/N 18282040 N1738SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12287 N173AWLongwing Company LLC · Plymouth, MNBuilt 2022 · S/N 172S12859 N173CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283269 N173DCSkyvibe Leasing LLC · Aurora, ORBuilt 2016 · S/N 172S11720 N173EMGasa Capital LLC · Laredo, TXBuilt 2007 · S/N T18208793 N173MEBox Aviation Inc · Montgomery, ALBuilt 2000 · S/N 172S8455 N173PBLee Bradford W · Austin, TXBuilt 2003 · S/N 172S9442 N17409Cirrus Aviation Inc · Sarasota, FLBuilt 2008 · S/N 172S10660 N1740CAmerican Aviation Inc · Brooksville, FLBuilt 2007 · S/N 172S10610 N1740TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12087 N1741SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12288 N1742SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12289 N1743LAir Inter LLC · Pittsburgh, PABuilt 2008 · S/N 172S10665 N1743SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12290 N1744LDdd Aviation LLC · Phoenix, AZBuilt 2008 · S/N T18208815 N1745LPark West Communities Inc · Lake Havasu City, AZBuilt 2008 · S/N T18208817 N1745SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12291 N1747LCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 17281489 N174GFMarcus Air LLC · Plano, TXBuilt 1998 · S/N 17280532 N174HFHeritage Asset Leasing LLC · Ronkonkoma, NYS/N 172S8257 N174MEMaxxum Financial Group Inc · Destrehan, LABuilt 2000 · S/N 172S8452 N174THGh174th LLC · Jericho, NYBuilt 2020 · S/N 172S12442 N1752TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12097 N1754TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12099 N1756TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12104 N1756VMtp Flyers · Riverhead, NYBuilt 2005 · S/N 18281626 N17572Valencia Technical Consulting LLC · Gig Harbor, WABuilt 2005 · S/N 18281628 N175CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282337 N175MENorth Perry Flight Center Inc · Fort Lauderdale, FLBuilt 2000 · S/N 172S8437 N1760TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12108 N1762TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12109

Back to AD 2005-05-53 R1