Skip to content

Registered aircraft · 7,870

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:2003-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13') 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:2003-24-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13')
  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:2003-24-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13')
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.

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 N1737STms Aviation Inc · Wilmington, DEBuilt 2000 · S/N 18280763 N17386Oregon State Police · Salem, ORBuilt 2007 · S/N T20608800 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 N1740LMidsouth Marketing Inc · Colt, ARBuilt 2007 · S/N T20608784 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 N1746LNebraska State Patrol · Lincoln, NES/N T20608809 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 N174STMichigan State Police · Lansing, MIBuilt 2003 · S/N T20608400 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 N1756LSan Sophia LLC · West Linn, ORBuilt 2009 · S/N T20608920 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

Back to AD 2003-24-13