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.

N2431VAamodt Arne E · Soldotna, AKS/N 20608093N2431XDvirnak Paul · Hesperus, COBuilt 2006 · S/N T18208520N2432KChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280870N24334Sorbi Aviation Inc · El Cajon, CABuilt 2000 · S/N 17280887N24336Moody Bible Institute Of Chicago · Spokane, WABuilt 2000 · S/N 17280888N24337Dunn Craig M · Sarasota, FLBuilt 2000 · S/N 18280713N2433EElco Electric · Bangor, MEBuilt 2000 · S/N 20608136N2433SN2433s LLC · Manassas, VABuilt 2000 · S/N 17280872N2433UEddleman David Baggett · Mclean, VABuilt 2001 · S/N T18208006N2434YRegistration Pending · Cedar Falls, IARegistration pendingBuilt 2000 · S/N 20608078N24350Aero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10144N24352National Training I LLC · Wilmington, DEBuilt 2000 · S/N 17280835N2435CAzure Skies LLC · Bloomington, INBuilt 1999 · S/N 18280644N2436NThunderbird Aviation · Bloomington, MNBuilt 2000 · S/N 17280842N2436VGt Holdings LLC · Nashville, TNBuilt 2006 · S/N 18281786N2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeBuilt 2000 · S/N 17280841N24376C R Transport Inc · Wilmington, DEBuilt 2000 · S/N 18280704N2437LLean Enterprises Inc · Brookhaven, MSBuilt 2006 · S/N 18281791N2437WAllen Larry D · Bellingham, WAS/N 18280705N24389Way Of The Lord LLC · London, KYBuilt 2000 · S/N 18280708N2438AHorse Creek 3518 Inc · Hollywood, FLBuilt 2006 · S/N 18281793N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878N2438FMackie Scott Christopher · Elkton, MDBuilt 2006 · S/N 18281794N2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeBuilt 2000 · S/N 17280875N2439BVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18280955N2439C206 Aircraft Leasing Co Inc · Marathon, FLBuilt 2000 · S/N 20608100N2439DN2439d LLC · Oklahoma City, OKBuilt 2006 · S/N T18208525N2439RAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2006 · S/N T18208526N2439SBright Scott Devin · Platteville, COBuilt 2006 · S/N T18208528N2439TSkylane 2439t Partners LLC · Burlingame, CABuilt 2000 · S/N 18280810N2439ZPlane Nonsense Inc · Middletown, DEBuilt 2007 · S/N 172S10564N243AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13223N243CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12338N243EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13281N243HAAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11583N243MCRankin John · Nokomis, FLBuilt 2004 · S/N T18208243N243MEMcaleer William V Jr · Milledgeville, GABuilt 2000 · S/N 20608113N243RLAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11595N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212N2440PN2440p LLC · Seattle, WABuilt 1999 · S/N T20608136N2440QTeanaway Ventures Consulting LLC · Cle Elum, WABuilt 2001 · S/N 18280937N2440VVehrs Roger K · Roseburg, ORBuilt 2000 · S/N T20608176N2441DKsm Aviation Inc · Wilmington, DEBuilt 2000 · S/N 17280983N2441EMyf Holdings LLC · San Diego, CABuilt 2000 · S/N 17280879N2441GTognoli Stefano F · Union, ORBuilt 2000 · S/N T20608173N2441XPippy LLC · Naples, FLBuilt 2006 · S/N 18281802N2441YTag Aviation LLC · Santa Teresa, NMBuilt 2000 · S/N T20608169N24429Pniak Robert J · Carmel Valley, CABuilt 2000 · S/N 18280700N2442QCoastal Business Systems Inc · Eureka, CABuilt 2001 · S/N 18280938N2443HSilver Star Jet LLC · Delafield, WIBuilt 2000 · S/N 18280702
Back to AD 2003-24-13