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.

N22761Kop Aviation LLC · El Paso, TXBuilt 2007 · S/N T18208734N2277TEngisys Traffic LLC · North Potomac, MDBuilt 2005 · S/N 172S9958N2278YWplanec LLC · Gig Harbor, WABuilt 2007 · S/N T18208736N227BHPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10662N227BSLec Aviation LLC · Winter Garden, FLBuilt 2007 · S/N 18281943N227CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13049N227RJFrost Cavin B · Odessa, TXS/N 18280383N227TFTop Flight Aviation Inc · Corona, CABuilt 2006 · S/N 18281826N227TWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9227N227WCHuerta Holdings Inc · Woodland Hills, CABuilt 2005 · S/N 172S9844N227WFTrayler James · Waco, TXBuilt 2004 · S/N T18208288N22801Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12906N22803Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12908N22806Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12911N22807Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12914N22808Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12915N22809Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12919N22810Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12921N22813Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12924N22816Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12925N22818Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12929N228AZCiaglia Caesar Earle · Mokena, ILBuilt 2009 · S/N T18208969N228HSSweeney David H · Houston, TXBuilt 2003 · S/N T20608419N228JPMazel Wings LLC · Camden, DEBuilt 2000 · S/N 18280711N228TWNorth Delta Aviation LLC · Blytheville, ARBuilt 2002 · S/N 172S9228N22904Phoenix East Aviation LLC · Daytona Beach, FLS/N 172S9961N2290AOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S9959N2291CForty Four Fifteen LLC · Reno, NVBuilt 2005 · S/N 172S9962N2291SRegistered aircraftBuilt 2007 · S/N T18208738N2292WA & L Enterprises LLC · Maiden Rock, WIBuilt 2023 · S/N T20609725N22952Winging It LLC · Lindon, UTBuilt 2007 · S/N T18208740N2296NMacsdea LLC · Van Nuys, CABuilt 2005 · S/N 172S9967N2297VTicknor Robert James · Adel, IABuilt 2007 · S/N T18208742N2298WGoli Aviation LLC · Raleigh, NCBuilt 2005 · S/N 172S9968N229CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283263N229CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282293N229ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608229N229LPDuke Air LLC · Romeo, MIBuilt 2003 · S/N 18281229N229METom Wood Aviation Inc · Fishers, INBuilt 2000 · S/N 172S8483N229WCJeffery & Weiss Holdings LLC · Long Beach, CABuilt 2016 · S/N 172S11669N22CHSupergo LLC · Menlo Park, CABuilt 1999 · S/N T20608101N22CSClear Skies Aviation Enterprise LLC · Dover, DEBuilt 2017 · S/N T20609504N22CUGbh Aviation · Santa Monica, CABuilt 2007 · S/N T18208773N22HYTlc2 LLC · Missoula, MTBuilt 2024 · S/N T18209150N22SJWright James M · San Diego, CABuilt 1999 · S/N 172S8345N2301QFarm West LLC · Missoula, MTBuilt 2001 · S/N T20608263N2302YMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9973N230BKErickson Bernard Rudolph · Saint Cloud, MNBuilt 2023 · S/N T20609747N230CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282347N230EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13092
Back to AD 2003-24-13