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.

N5205UVoloshin Vitaly Alexandrovich · Seattle, WABuilt 2002 · S/N T18208153N52070Cendejas Agustin · Chino, CABuilt 2002 · S/N 172S9077N52072Wicked Wings Aviation LLC · Dover, DEBuilt 2002 · S/N 18281137N5208S5fs Aviation LLC · Lewes, DEBuilt 2002 · S/N 18281138N5209FMidwest Avtech Inc · South Barrington, ILBuilt 2002 · S/N T18208155N5209POliver Dennis L · Williamsburg, IABuilt 2002 · S/N T18208156N520EPMiles In The Sky LLC · Springfield, MOBuilt 2010 · S/N 18282274N520ERN520er LLC · New Orleans, LABuilt 2001 · S/N 172S8923N520FSCloud One Flying Club Inc · Kansas City, MOS/N 18281091N520KSH2 Link Company · Lewes, DEBuilt 2004 · S/N 172S9734N520LHH2 Link Co · Lewes, DEBuilt 2004 · S/N 172S9731N520PLRdp Aviation LLC · Gig Harbor, WABuilt 2005 · S/N 172S9887N520WBVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282049N5210AChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9118N5210QFortress Group LLC · Thompsons Station, TNBuilt 2002 · S/N 18281140N5211VPipe Dream LLC · Stout, OHBuilt 2002 · S/N T20608379N52128Glasslane LLC · Wilmington, DES/N T18208158N5212XMoore John S · Strafford, NHBuilt 2002 · S/N 172S9120N5213FJefferson City Aviation Inc · Jefferson City, MOBuilt 2002 · S/N 172S9124N5213MFlight Training Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 172S9127N5215JIndigo Air LLC · Newburgh, NYBuilt 2002 · S/N 172S9128N5216ULeopard Air LLC · Oklahoma City, OKBuilt 2002 · S/N 172S9130N5218FMacmillan Performance LLC · Torrance, CABuilt 2002 · S/N 172S9132N5218UWnc Aviation LLC · Arden, NCS/N 172S9133N5218YMcintire Aviation LLC · Middletown, DEBuilt 2002 · S/N 18281147N5219EUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608383N5219VSkymates Inc · Wilmington, DEBuilt 2002 · S/N 172S9138N521AFChhh LLC · Raleigh, NCBuilt 2003 · S/N 18281194N521CAAftcloud Inc · Ontario, CABuilt 2004 · S/N 172S9733N521DBBowling Donald W · Greensburg, INBuilt 2006 · S/N 18281823N521DJCuff Ronald J Trustee · Paso Robles, CABuilt 2000 · S/N 18280858N521EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12623N521ER521er LLC · Blaine, MNBuilt 2001 · S/N 172S8924N521JDH&G Farms Inc · Corcoran, CABuilt 1998 · S/N 172S8027N521JTDeralex Airways LLC · Miami, FLBuilt 1998 · S/N 172S8013N521KSKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 17280519N521MCBarr Air Patrol LLC · Mesquite, TXBuilt 2004 · S/N 172S9730N521NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10975N521SDMedary Aviation LLC · Brookings, SDBuilt 2024 · S/N 172S13137N521TKCato Air LLC · Wilmington, DEBuilt 2005 · S/N 18281673N52208Eastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9208N5220AMarshall Chadwick J · Fort Walton Beach, FLBuilt 2002 · S/N 18281149N5222GHanger C16 LLC · Pinckney, MIBuilt 2002 · S/N T18208164N52232Mustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10870N5223MGraham Holdings Inc · Atherton, CANon-citizen corporation, flight hours not reportedBuilt 2002 · S/N 20608180N5223SFrancis Larry Wayne · Whitewright, TXBuilt 2003 · S/N T20608384N52241Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10879N5224EFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10875N5224GBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 172S9144N5225LFirst Aero LLC · Edmonds, WABuilt 2002 · S/N 18281151
Back to AD 2003-24-13