AD 2002-11-05

Registered aircraft · 948

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:2002-11-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-05')
  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.

N1529WOlathe Spray Service Inc · Olathe, COBuilt 1992 · S/N 401-0848N1531GWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 402-0850N1531SWakefield Aircraft LLC · Cooperstown, NDBuilt 1991 · S/N 802-0002N1533SMj Aviation Inc · Walnut Ridge, ARBuilt 1991 · S/N 402-0847N1534DEdge Aviation LLC · Moberly, MOBuilt 1992 · S/N 402A-0855N15439Dietz Timothy E · Wasilla, AKS/N 401-0862N15449Headwaters Flying Service LLC · Three Forks, MTBuilt 1992 · S/N 401-0868N1544RRas Aviation LLC · Elyria, OHBuilt 1992 · S/N 401-0864N1546HAero Spray Inc DBA · Appleton, MNBuilt 1992 · S/N 802A-0003N1546UBauer Charles A · Graceville, MNBuilt 1992 · S/N 401-0873N1546XHopkins Robert E Jr · Sumter, SCBuilt 1992 · S/N 401-0874N1554KBasin Aviation Inc · Rio Oso, CAS/N 401-0882N15570Shearer Sprayers Inc · The Dalles, ORBuilt 1992 · S/N 402-0884N157LAWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0157N166LAAeronautical Technologies Inc · Clovis, NMBuilt 2004 · S/N 802A-0166N169JTTidwell Flying Service Inc · Carlisle, ARBuilt 2014 · S/N 802A-0574N173TANew Frontier Aviation LLC · Fort Benton, MTBuilt 2004 · S/N 802A-0178N174MLNew Frontier Aviation LLC · Fort Benton, MTBuilt 2003 · S/N 802A-0168N175LAMitchell Andrew D Trustee · Winnie, TXBuilt 2004 · S/N 802A-0175N1802MMeyerkorth Aviation LLC · Rock Port, MOBuilt 2016 · S/N 802A-0678N1802QPontiac Flying LLC · Pontiac, ILBuilt 2012 · S/N 802A-0484N182PBDodson International Parts Inc · Rantoul, KSS/N 402-0806N187LALocker Fred · Muleshoe, TXBuilt 2001 · S/N 802A-0108N18KDH & W Ag Services Inc · Veribest, TXBuilt 2007 · S/N 402B-1187N194BMBombero Aviation LLC · Childress, TXBuilt 2008 · S/N 802A-0283N194CAAir Tractor Inc · Olney, TXS/N 802A-1350N196CFAir Tractor Inc · Olney, TXS/N 802A-1277N196LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0196N20001Dcs Air LLC · Lewes, DEBuilt 2011 · S/N 802A0418N2003YOops LLC · Cheyenne, WYBuilt 2011 · S/N 802A-0428N200LAAsap Flying Service Inc · Hermiston, ORBuilt 2008 · S/N 802A-0292N200WHDcs Air LLC · Lewes, DEBuilt 2018 · S/N 802A-0755N2017NKen Grubbs Aero Inc · Harrisburg, ARBuilt 2011 · S/N 802A-0429N2022BWil-Co Flying Service LLC · De Witt, ARBuilt 2011 · S/N 802A-0433N2022QHartley Flying Service Inc · Stuttgart, ARBuilt 2011 · S/N 802A-0435N202FHTr Flying Service LLC · Milan, MNBuilt 1992 · S/N 402A-0867N2039YDelta Dusters LLC · Newellton, LABuilt 2011 · S/N 802A-0403N2047VWilliamsburg Air Service Inc · Kingstree, SCBuilt 2012 · S/N 402B-1253N205KCWalton Agwings Inc · Jonesboro, ARBuilt 2017 · S/N 802A-0728N20607Neal Aircraft Inc · Slaton, TXBuilt 2012 · S/N 802A-0439N2060HCleveland Air Service Inc · Cleveland, MSBuilt 2013 · S/N 802A-0497N2060MAerial Crop Protection Inc · Stuart, FLBuilt 2012 · S/N 802A-0437N2064JPadgett Ag Rotors LLC · Missoula, MTS/N 802-0450N2065SSteggs Aerial Spraying Inc · Alva, OKBuilt 2012 · S/N 802A-0487N2067EFarm Air Flying Service LLC · Sacramento, CABuilt 2012 · S/N 802A-0440N20700Meyerkorth Aviation LLC · Rock Port, MOBuilt 2012 · S/N 802A-0486N20718Cartillar Enterprises Inc · Wynne, ARS/N 802A-0465N20726A&M Flying Service Inc · Carlisle, ARS/N 802A-0468N2072DPadgett Ag Rotors LLC · Missoula, MTBuilt 2012 · S/N 402B-1268N207LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0207
Back to AD 2002-11-05