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.

N4612JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2011 · S/N 602-1203N469LACounty Line Flying Service Inc · Coy, ARBuilt 2012 · S/N 802A-0469N4712JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2013 · S/N 602-1225N471HKSak II LLC · Miller, SDBuilt 2021 · S/N 802A-0883N473FSShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2012 · S/N 802A-0473N474HAg Solutions Of West Texas LLC · Roby, TXBuilt 2006 · S/N 802-0252N474LACat Agri Aviation Inc · Walnut Ridge, ARBuilt 2012 · S/N 802A-0474N475LAPost Rock Aviation Inc · Lincoln, KSBuilt 2006 · S/N 402B-1175N482ATAerinova Aerial LLC · Mattoon, ILBuilt 2013 · S/N 402B-1280N490SFWells Flying Services LLC · Holdrege, NEBuilt 2024 · S/N 802A-1152N496JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 602-1171N49PAState Exchange Bank · Lamont, OKS/N 602-0631N5002WSouther Crop Spraying Inc · Douglas, GABuilt 1997 · S/N 802A-0038N5003XJagco Inc · Middletown, DEBuilt 1998 · S/N 602-0488N50050Mowata Farms LLC · Mamou, LABuilt 1998 · S/N 602-0485N5005KFisher Spray Service LLC · Cardington, OHBuilt 1997 · S/N 602-0403N5006CAir Tractor Inc · Olney, TXS/N 802-4071N5006GBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 602-0416N5006KWoods Aviation LLC · Kearney, NEBuilt 1997 · S/N 402B-1024N50071South Delta Aviation Inc · West Helena, ARBuilt 1996 · S/N 402B-1019N5008LOlathe Spray Service Inc · Olathe, COBuilt 1996 · S/N 402B-1018N5008YAir Tractor Inc · Olney, TXS/N 802-4066N5009PAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802-4058N50102Air Tractor Inc · Olney, TXS/N 802-4068N50105Air Tractor Inc · Olney, TXBuilt 2026 · S/N 802-4059N5011DAir Tractor Inc · Olney, TXS/N 802A-1342N5011HAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802-4060N5012GAir Tractor Inc · Olney, TXS/N 802-1349N5012HEvergreen Flying Service Inc · Dover, DES/N 802A-1291N5012LAir Tractor Inc · Olney, TXS/N 802-4069N5012TAir Tractor Inc · Olney, TXS/N 802-4070N5012XAir Tractor Inc · Olney, TXS/N 802-4061N5013FAir Tractor Inc · Olney, TXS/N 802-4062N5013MAir Tractor Inc · Olney, TXS/N 802-4063N5013VAir Tractor Inc · Olney, TXS/N 802-4064N5013ZAir Tractor Inc · Olney, TXS/N 802-4065N5014FAir Tractor Inc · Olney, TXS/N 802-4067N5014NAir Tractor Inc · Olney, TXS/N 802A-1327N5015KBirddog Aviation LLC · Stockton, KSS/N 602-0429N5019YAir Sprayers Inc · Two Buttes, COS/N 402A-1071N501JC4l A/C Leasing LLC · Port Saint Lucie, FLBuilt 2013 · S/N 802A-0501N5021UReed Aviation Inc · Iota, LABuilt 1998 · S/N 602-0490N50256Panola Flying Service LLC · Lake Providence, LABuilt 1998 · S/N 402A-1059N5034RMid Missouri Spray Service LLC · Richmond, MOBuilt 1996 · S/N 402B-1020N5035KAmberican Aviation Inc · Grand Forks, NDBuilt 1997 · S/N 802-0048N5039FDixie Flying Service Inc · Gilliam, LABuilt 1997 · S/N 402A-1031N503FAMccaleb'S Flying Service LLC · Plaucheville, LABuilt 2013 · S/N 802A-0503N5043DSterling John A · Port Lavaca, TXS/N 602-0470N5045SAw Peterson Inc · Warren, MNBuilt 1997 · S/N 602-0423N5048DFitchs Flying Service LLC · Pearsall, TXBuilt 1998 · S/N 602-0469
Back to AD 2002-19-10