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.

N2338WChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280698N233AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2004 · S/N 172S9770N233CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12336N233DCMc Aviation Holdings LLC · Miami, FLBuilt 1998 · S/N 18280289N233EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13096N233FFArq Aviation LLC · Wilmington, NCBuilt 2026 · S/N 172S13573N233KSJean Buford Randall · Lorena, TXBuilt 1998 · S/N 18280145N233MEEight Ball Flying Club · Van Nuys, CABuilt 2000 · S/N 18280750N233TSLittle Sunflower LLC · Bridgewater, CTBuilt 2006 · S/N T18208523N23407S C Skylane LLC · Cumming, GABuilt 1998 · S/N 18280409N23480Pkp Aviation LLC · Alexandria, VABuilt 1999 · S/N 18280412N2348SGeorgia Forestry Commission · Macon, GABuilt 1999 · S/N 18280411N23497Full Throttle Aviation LLC · Clayton, DEBuilt 2007 · S/N 172S10512N2349RSalser Aviation LLC · Ocala, FLBuilt 1998 · S/N 18280413N2349XNorris James A · Export, PABuilt 1998 · S/N 18280414N234EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13098N234FFAviato I LLC · Palo Alto, CABuilt 2026 · S/N 172S13574N234HESchniederjan William Jason · Dalhart, TXBuilt 2011 · S/N T20609013N234LPDethloff Joseph · St Johns, FLS/N 18281047N234MESanfilippo Joseph J · Hollywood, FLBuilt 2000 · S/N 18280751N234MFGone Flying LLC · Salt Lake City, UTBuilt 2006 · S/N T18208492N234SHAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11609N234USouthwest Aviation Enterprises · Haslet, TXBuilt 2005 · S/N 20608230N2350HRieder John · Camarillo, CABuilt 2005 · S/N 18281706N2351EHog Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 18281707N23521Aircraft Holdings LLC · Missoula, MTBuilt 1998 · S/N 18280418N2352BGwyn Farms Inc · Moses Lake, WABuilt 1998 · S/N 18280416N2352MCloud Cap Technology · Hood River, ORBuilt 1999 · S/N 18280417N23530Registration Pending · Grapevine, TXRegistration pendingBuilt 2022 · S/N T20609691N2353HBlackbird Enterprises LLC · Las Vegas, NVS/N T20608749N2353KGraff Lars U · Kohler, WIBuilt 1998 · S/N 18280420N23556Aerospring Leasing LLC · Wasilla, AKBuilt 2005 · S/N 172S10095N23557Flying Dutchman LLC · Wilmington, DEBuilt 2005 · S/N 172S10096N2355PDice Jeremy L · Redmond, ORBuilt 2007 · S/N T18208750N23563Aircraft Leasing And Sales LLC · Riviera Beach, FLBuilt 2007 · S/N T18208754N23566Sunrise Aviation Inc · Ormond Beach, FLBuilt 2005 · S/N 172S10097N2356EHock Aviation LLC · Stuart, FLBuilt 1999 · S/N 18280423N2356LCircle B Pipe & Supply LLC · Odessa, TXBuilt 1998 · S/N 18280425N23581So Cal Leasing LLC · El Cajon, CABuilt 1998 · S/N 17280595N2359GAllison Farms Inc · Wray, COBuilt 2023 · S/N T18209126N235CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13084N235EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13099N235HP235hp LLC · Norwood, NCBuilt 1998 · S/N 18280333N235MERegistered aircraftBuilt 2000 · S/N 18280753N235PXGons Stephen E · Camp Hill, PABuilt 2022 · S/N 18283176N2360ARegistration Pending · Cedar Falls, IARegistration pendingS/N 20608016N2362CCelek Brian F · Charleston, SCBuilt 1999 · S/N 18280474N2362JBauer Bryce · Forestville, CABuilt 1999 · S/N 18280475N2363KJerk Assets LLC · Bakersfield, CABuilt 2001 · S/N 172S8817N2363S182 Skylane LLC · Loxahatchee, FLS/N 18280478
Back to AD 2003-24-13