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.

N194DDLcb Leasing · Bristow, VABuilt 2015 · S/N T20609194N194SPFly4sp LLC · San Mateo, CABuilt 2003 · S/N 172S9459N194THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11552N194TWGreenway William Kendal · Greensboro, GABuilt 2014 · S/N T20609145N1955TFredericksen John · Cedarburg, WIBuilt 2021 · S/N 18283157N1956VMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9934N1957KVan Bortel Aircraft Inc · Arlington, TXBuilt 2013 · S/N T18209091N195FAPinkston Pat · Carrollton, ILBuilt 2002 · S/N 18281095N195NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11095N1962GGr Aviation LLC · Key Biscayne, FLBuilt 2015 · S/N T20609159N1962KMria LLC · Albuquerque, NMBuilt 2013 · S/N T20609092N1965HDeltahawk Engines Inc · Racine, WIBuilt 2005 · S/N 172S9937N196CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609136N196MEPacific Lease · Elk Grove, CABuilt 2000 · S/N 172S8471N196PWC I Mckown & Son Inc · Newton, WVBuilt 2004 · S/N 18281368N196SA3d Capture LLC · Beaumont, TXBuilt 2003 · S/N 20608197N196TTNbr Aviation · Bristow, VABuilt 2015 · S/N T20609196N196TWTango Lima Flying LLC · Lawrence, KSBuilt 2011 · S/N T20609019N197BALewis University · Romeoville, ILBuilt 1997 · S/N 17280314N197MCLewis University · Romeoville, ILBuilt 2006 · S/N 172S10197N197MEPremier Air Of Delaware Inc · Flemington, NJBuilt 2000 · S/N 172S8472N197TACoast Aviation LLC · Costa Mesa, CABuilt 2002 · S/N 172S9197N197WSObr Leasing · Bristow, VABuilt 2015 · S/N T20609197N1982KN1982k LLC · Wilmington, DEBuilt 2005 · S/N T18208442N1986VSpeer 182 LLC · Kalispell, MTBuilt 2005 · S/N T18208443N198BWFixed Wing Holding Co Inc · Pembroke Pines, FLS/N 17280382N198MECal Aggie Flying Farmers · Davis, CABuilt 2000 · S/N 172S8473N198PGSun City Aviation LLC · Davie, FLBuilt 2001 · S/N 172S8851N198RNKqm Aviation · Bristow, VABuilt 2015 · S/N T20609198N198SPFlight Training Aircraft LLC · Wilmington, DEBuilt 2003 · S/N 172S9465N198THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11554N1992DRiggan Russell C · Kirkwood, MOBuilt 2005 · S/N 18281716N1995BN2jz LLC · Amarillo, TXBuilt 2005 · S/N 18281697N1998FSpartan Education Group LLC · Tulsa, OKBuilt 1998 · S/N 17280347N1998RA & E Flying Club Of Los Angeles Inc · Hawthorne, CABuilt 1998 · S/N 17280389N199CACapital Holdings 109 LLC · Potomac, MDBuilt 2005 · S/N 18281548N199PWJ & C Express Inc · Carbondale, ILBuilt 2017 · S/N T20609506N199RAN199ra LLC · Huntington Woods, MIBuilt 1999 · S/N 18280636N199SHPrecision Design Inc · Wilmington, DEBuilt 2008 · S/N 18282078N199SPW Air LLC · Wheeling, ILBuilt 2003 · S/N 172S9467N199TEPxw Services · Greenville, DEBuilt 2015 · S/N T20609199N19CMRedrock Aviation LLC · Missoula, MTBuilt 2011 · S/N T18209020N19DKRichardson Cotton Inc · Wilmington, DEBuilt 2015 · S/N 18282374N19HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2003 · S/N 18281266N19KHVan Bortel Aircraft Inc · Arlington, TXS/N 18282073N19LMM & M Skyshare LLC · Winter Park, FLBuilt 2024 · S/N T20609790N19MVSky Path Aviation LLC · Sheridan, WYBuilt 2019 · S/N 172S12273N19SCSacred Heart Medical Group Inc · Riverside, CABuilt 2001 · S/N T18208101N1FRApex Aero LLC · Kalispell, MTS/N T18208002N1LYAll About Lawns Inc · Sebring, FLBuilt 2000 · S/N 18280826
Back to AD 2003-24-13