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.

N134KAHgj Capital Holdings LLC · Newark, DEBuilt 2007 · S/N T18208671 N134PJHelibro LLC · Red Bluff, CABuilt 2002 · S/N 172S9187 N134VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281191 N1359BLagos Aero LLC · Houston, TXBuilt 2007 · S/N 18281880 N135GVreeland Equipment Rental LLC · Dayton, OHBuilt 1999 · S/N T20608077 N135PJAviator Air Operations LLC · Grand Prairie, TXBuilt 2000 · S/N 172S8406 N135TDDunlay Regis Terry · Albuquerque, NMBuilt 2019 · S/N 18283082 N135TRTrue Equipment Leasing LLC · Bozeman, MTBuilt 2011 · S/N T18209039 N135TSN135ts LLC · Lima, OHBuilt 2003 · S/N T20608413 N135VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281192 N1361MLux Aero Operations LLC · Belmont, CABuilt 2005 · S/N 172S9842 N1369QAmeriflyers Of Texas Inc · Addison, TXBuilt 2005 · S/N 172S9946 N136HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9711 N136VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281193 N13709Personal Wings Inc · San Diego, CABuilt 2007 · S/N T20608706 N1377SUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 2005 · S/N 172S9840 N137CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N T18209143 N137CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13486 N137MACivil Aviation Inc · Waukesha, WIBuilt 1997 · S/N 17280146 N137MEChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8420 N137PFerguson Frampton Z · Furman, SCS/N 20608304 N137RJUaa International Inc · La Verne, CABuilt 1999 · S/N 172S8296 N137TSArk Aviation LLC · Moncks Corner, SCBuilt 2003 · S/N T20608415 N137VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281194 N1389BColumbia Safety Medical LLC · Kennewick, WABuilt 2005 · S/N T18208455 N138AZTablemax Aeronautics LLC · El Paso, TXBuilt 2004 · S/N T18208355 N138MEA&R Aero LLC · Sacramento, CABuilt 2000 · S/N 172S8422 N138UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11487 N1391AAqua Aviation LLC · Danville, CABuilt 2007 · S/N T18208723 N13974Total Prf LLC · New Smyrna Beach, FLBuilt 2006 · S/N 172S10409 N13986Euro 2000 Inc · Merritt Island, FLBuilt 2008 · S/N 17281503 N139METotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2000 · S/N 172S8423 N139RABeach Cruisers LLC · Ormond Beach, FLBuilt 1999 · S/N 18280614 N139SAMississippi Forestry Commission · Pearl, MSBuilt 2003 · S/N 20608195 N139TWMcghee James Allen · Houston, TXBuilt 2002 · S/N 172S9139 N139UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11488 N13HNAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13255 N13WNRegistered aircraftBuilt 2026 · S/N T20609838 N14007Kga Aviation LLC · Alfred, MEBuilt 2005 · S/N 18281589 N14008Suburban Air Corp · Castro Valley, CABuilt 2005 · S/N 172S9886 N1400HAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10410 N1403RMy Way Aviation LLC · Weston, FLS/N 172S9877 N1407DFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10666 N1408BIasco Flight Training Inc · Redding, CABuilt 2006 · S/N 172S10429 N140CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13254 N140CTKollar Aviation LLC · Apollo Beach, FLBuilt 2015 · S/N 18282382 N140RADenome Vincent G · Tampa, FLBuilt 1999 · S/N 172S8312 N140SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11563 N140TAGuggenair LLC · Carbondale, COBuilt 2002 · S/N T18208140 N140UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11489

Back to AD 2003-24-13