AD 2002-19-10

Registered aircraft · 1,092

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-19-10')
    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-19-10')
  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.

N402FHAasjng LLC · Holdrege, NES/N 402B-1254N402GKGress Air LLC · Dunbar, NEBuilt 2004 · S/N 402A-1151N402JDefenbaugh Matthew J · Biggsville, ILBuilt 2000 · S/N 402A-1117N402JGWhalen Mark P · Millington, MDBuilt 2013 · S/N 402B-1277N402JWKeahey Aviation LLC · West Monroe, LAS/N 402B-1249N402KKKevin Kingsley LLC · Lamar, MOBuilt 2020 · S/N 402B-1430N402LTBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 402B-1163N402PRBarts Flying Service Inc · Storm Lake, IABuilt 2013 · S/N 402B-1282N402REKingrey William S III · Richmond, TXBuilt 1997 · S/N 402A-1027N402SKOli Grow LLC · Baskin, LAS/N 402-0895N402SROli Grow LLC · Baskin, LABuilt 1994 · S/N 402-0939N402TSunflower Aero Inc · Atwood, KSBuilt 1998 · S/N 402A-1060N402TMShores Ag-Air Inc · Robstown, TXBuilt 2005 · S/N 402B-1164N402TTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 402B-1304N402UWestern Ag Aviation Inc · Plains, KSBuilt 1999 · S/N 402A-1116N402VA + Aviation Services LLC · Goodland, KSBuilt 1998 · S/N 402A-1050N402WD402wd Holdings LLC · Corpus Christi, TXBuilt 1999 · S/N 402A-1090N402WRHoxie Sprayers Inc · Hoxie, KSBuilt 2011 · S/N 402B-1244N402YSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 402B-1285N402ZSevcik Clint · Medford, MNBuilt 2012 · S/N 402B-1252N4036FSaffer Spray Service Inc · Fowler, COS/N 402A-1058N406BMEvergreen Flying Service Inc · Rayville, LABuilt 2007 · S/N 802-0265N40LAMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 802A-0182N41068Woodley Aerial Leasing LLC · Walnut, ILS/N 402B-1174N4106AAir Cover Crop Solutions LLC · Frankford, MOBuilt 2005 · S/N 802A-0223N41119Crop Jet Aviation LLC · Gooding, IDS/N 802A-0229N411GRLake Air Service LLC · Jennings, LABuilt 2002 · S/N 602-0642N411GSWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 602-0466N4120RTumbleweed Leasing LLC · Tacoma, WAS/N 802A-0232N4122XEllis Flying Service Inc · Newport, ARBuilt 2017 · S/N 802A-0692N4149PPonderosa Airtankers LLC · Safford, AZBuilt 2007 · S/N 802A-0255N41525County Line Flying Service Inc · Coy, ARS/N 802A-0231N41588Echo Fox Leasing LLC · Wilmington, DES/N 6021143N41600Patriot Ag Air LLC · Huntington, INBuilt 2010 · S/N 602-1187N41613All In Flying Co · Wilmington, DEBuilt 2008 · S/N 802A-0273N41647Odessa Air Service Inc · Moses Lake, WABuilt 2007 · S/N 802A-0279N41651Bank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 602-1164N41687Over The Top Aviation Inc · Jonesboro, ARBuilt 2008 · S/N 802A-0309N4170SLowry Flying Service Inc · Grinnell, IAS/N 802A-0278N4172USki Ag Aviation LLC · Bismarck, NDBuilt 2010 · S/N 402B-1228N417BMMilhon Air Inc · Martinsville, INBuilt 2007 · S/N 802A-0276N419FFMccreary Flying Service LLC · Clarksdale, MSS/N 802A-0191N419TWMidwest Agri Drone LLC · Saint Joseph, MOBuilt 2014 · S/N 602-1251N42022Central Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2009 · S/N 602-1169N4203WFast Ag Air LLC · Watertown, SDBuilt 2006 · S/N 802A-0253N420SAKingrey William S III · Richmond, TXBuilt 1990 · S/N 402-0776N4212JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2009 · S/N 602-1177N4215WAero Applicators Inc · Sterling, COBuilt 2009 · S/N 402B-1211N4216KBecker Barton C · Oneill, NES/N 402A-1219N4216WTri Air Farms LLC · Mamou, LAS/N 802A-0320
Back to AD 2002-19-10