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.

N649TLamonds Donald · Advance, NCBuilt 1998 · S/N 18280261N649TCSpartan Education Group LLC · Tulsa, OKBuilt 2000 · S/N 172S8649N64AFVermont Flight Academy · South Burlington, VTBuilt 1997 · S/N 17280069N64GLStalagmite LLC · Demarest, NJBuilt 2015 · S/N T20609205N64JAJet Air Inc · Iowa City, IABuilt 2001 · S/N 17281065N64PWM&G Aircraft Management LLC · Aurora, ORBuilt 2024 · S/N 172S13212N64WGM&G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12753N64WTTietmeyer Scott W · Grover, COBuilt 2006 · S/N T18208590N650MATerra Flight Aerial Imaging Inc · Spring, TXBuilt 1999 · S/N T20608120N650TMSouthwest Construction & Property Management Inc · S San Fran, CABuilt 2006 · S/N T18208650N651EREmbry-Riddle Aernautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13085N651MAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 2000 · S/N 17280897N651PASmn Investments Inc · Greeneville, TNBuilt 2017 · S/N 172S12016N652171434 Jpl LLC · Wilmington, DEBuilt 2004 · S/N 18281415N65225Leon Manuel Perez · Lake Worth, FLBuilt 2004 · S/N 18281414N65234Moore Tommy Vance · Monahans, TXBuilt 2004 · S/N T18208301N65236Taylor Jonathan P · Danbury, CTBuilt 2004 · S/N 18281417N652515280 Flying Club LLC · Castle Pines, COBuilt 2004 · S/N 172S9690N65260Aircraft Guaranty Corp Trustee · Oklahoma City, OKS/N T20608465N65279Ferrara Joseph Vincent · Port Saint Lucie, FLBuilt 2004 · S/N 18281488N65280Jacobson David A Trustee · Bend, ORBuilt 2004 · S/N T20608467N65283Ag N65283 LLC · South Salt Lake, UTS/N T20608469N65290So Cal Leasing LLC · El Cajon, CABuilt 2004 · S/N 172S9693N652CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N T18208652N652EPChristiansen Aviation LLC · Wilmington, DEBuilt 2016 · S/N 172S11691N652FCFlorida Department Of Agriculture And Consumer Svc · Tallahassee, FLS/N 18282383N652JHausmann Aero LLC · Grand Forks, NDBuilt 2022 · S/N T20609689N652MAAbove And Beyond Aviation LLC · Austin, TXBuilt 2000 · S/N 17280903N652NDInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 172S11468N652PASmn Investments Inc · Greeneville, TNBuilt 2017 · S/N 172S12017N652SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8058N65306Bullet Power Brokers Inc · Stuart, FLBuilt 2004 · S/N 18281420N65309Satoyama Molokai LLC · Kaunakaka Molokia, HIBuilt 2004 · S/N T20608482N65311Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9695N65324Bickerstaff Mike · Port Orange, FLBuilt 2004 · S/N 18281421N65328Lingyun LLC · Winter Garden, FLBuilt 2004 · S/N 18281462N65329Advanced Aviation Group LLC · Frederick, MDBuilt 2004 · S/N 172S9702N65330Flight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 172S9703N65331Maxxum Financial Group Inc · Destrehan, LABuilt 2004 · S/N 172S9704N65348Anselmetti Federico · South Miami, FLBuilt 2004 · S/N T18208311N65358Peanut Productions LLC · Sheridan, WYBuilt 2004 · S/N 18281424N65367Wheels Up Re LLC · Odenville, ALBuilt 2004 · S/N 18281435N65371Border States Paving Inc · Fargo, NDS/N T20608488N65380Mikol Gabriel · Burlington, WIS/N 172S9710N6538WVenture Flying LLC · Mobile, ALBuilt 2004 · S/N 18281440N653EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2019 · S/N 172S12399N653KBSkyhawk Aviation Inc · Marietta, GABuilt 2000 · S/N 172S8686N653NDPelican Flight Training LLC · San Carlos, CABuilt 2014 · S/N 172S11469N653PAPurdue Aviation LLC · West Lafayette, INBuilt 2018 · S/N 172S12163N653PKBilavy Inc · Odessa, TXBuilt 2016 · S/N T20609253
Back to AD 2003-24-13