AD 2003-24-13

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
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.

N6033SSuburban Air Corp · Castro Valley, CABuilt 2006 · S/N 172S10191N60349Mb Aviation LLC · Mount Pleasant, TXBuilt 2006 · S/N T18208562N6034BFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2006 · S/N 172S10193N6034DDuro Vincent · Highland, CABuilt 2006 · S/N 172S10195N6034FToth Norman J · Spring Hill, FLBuilt 2006 · S/N 172S10196N6034ZN6034z LLC · Missoula, MTBuilt 2006 · S/N T18208560N60356Gray Family Acquisitions LLC · Loomis, CABuilt 2006 · S/N T18208571N6035ALandrys Aviation Services LLC · Pierre Part, LABuilt 2006 · S/N T18208563N6035HExclusive Auto'S LLC · Preston, IDS/N T18208564N60363Cumulus Aviation Services LLC · Port Orange, FLBuilt 2006 · S/N 172S10215N6036AClive Consulting LLC · Dover, DEBuilt 2006 · S/N T18208573N6036YChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10213N60372Above And Beyond Aviation LLC · Austin, TXBuilt 2006 · S/N 172S10216N6038VEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 18281832N60395American Aviation Inc · Brooksville, FLBuilt 2006 · S/N 172S10226N60397Vector USA LLC · Olive Branch, MSBuilt 2006 · S/N 172S10227N60398Wagoner Aviation LLC · Clovis, CABuilt 2006 · S/N 18281834N6039HMailing And Fulfilling America Inc · Fort Worth, TXFirst renewal noticeBuilt 2006 · S/N T18208581N603DCSeed Hub LLC · Glenarm, ILBuilt 2017 · S/N T20609502N603EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12701N603NDFm Aviation Services LLC · Arlington, VABuilt 2012 · S/N 172S11254N603TCReyes Gordon L · Houston, TXS/N 18280712N6040CZach Air Corp · Byfield, MAS/N 18281835N6040GPineland Holdings LLC · Gibsland, LABuilt 2006 · S/N 18281836N6040STait Layne S · Bloomington, INBuilt 2006 · S/N T18208589N6042NCal Aggie Flying Farmers · Davis, CABuilt 2006 · S/N 172S10228N6042ZL&G Skycatcher LLC · Bradenton, FLBuilt 2006 · S/N 172S10230N60430County Of Henrico Virginia · Henrico, VABuilt 2006 · S/N 18281839N60435Georgia Forestry Commission · Macon, GABuilt 2006 · S/N 18281840N60445Catskill Air LLC · Forestburgh, NYBuilt 2006 · S/N T18208593N60448Rlf N60448 LLC · Soap Lake, WABuilt 2006 · S/N T18208594N6044JJj Ventures LLC · Billings, MTBuilt 2006 · S/N T18208591N6044ZMunger Stanley E · Sioux City, IABuilt 2006 · S/N T18208601N60458Lindsarwatt Air LLC · Grand Junction, COBuilt 2006 · S/N T18208574N6045BPalmetto Flats LLC · Fort Pierce, FLBuilt 2006 · S/N T20608657N6045COrange County Sheriffs Department Rnsp · Santa Ana, CABuilt 2006 · S/N T20608648N6045UPronghorn Aviation LLC · Lubbock, TXBuilt 2006 · S/N T20608649N6046GBeyond Potential LLC · Tucson, AZBuilt 2006 · S/N T18208575N6046RIds Inc · La Quinta, CAS/N T18208577N6048THeartland Horseshoeing School Inc · Lamar, MOBuilt 2006 · S/N T20608639N6048ZRegistration Pending · Wilmington, DERegistration pendingBuilt 2006 · S/N 172S10217N6049KDeck Chair Air LLC · Bend, ORBuilt 2006 · S/N T18208582N6049SJ Birds LLC · Peyton, COBuilt 2006 · S/N T18208583N6049VBlackbird Alliance LLC · Rancho Mirage, CAS/N T18208585N604AGSgflight5 LLC · Lake Zurich, ILBuilt 2024 · S/N T20609763N604CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N T20609573N604DCRomee Aviation LLC · Dallas, TXBuilt 2017 · S/N T20609503N604EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12702N604NDHeavy Metal Air LLC · Farmingdale, NYBuilt 2012 · S/N 172S11255N604TTUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2008 · S/N 172S10735
Back to AD 2003-24-13