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.

N5059JTanner Flying Service Inc · Cortez, COBuilt 1997 · S/N 402B-1039N5059VKross Lessyn Aerial Inc · Hereford, TXBuilt 1998 · S/N 402B-1066N505FAAir Cover Crop Solutions LLC · Frankford, MOBuilt 2013 · S/N 802A-0505N50669Tri Rotor Spray And Chemical · Ulysses, KSBuilt 1997 · S/N 602-0447N5066CFarm Ag Enterprises LLC · Buckeye, AZBuilt 1997 · S/N 802A-0045N506FAPontiac Flying LLC · Pontiac, ILBuilt 2014 · S/N 802A-0572N5070HKubecka Operating Company Inc · Seminole, TXBuilt 1998 · S/N 602-0482N50738Farm Air Inc · Astoria, ILBuilt 1997 · S/N 602-0448N50761Arthur Aviation LLC · Arthur, NDBuilt 1998 · S/N 402A-1065N507FAGarrett Flying Service Inc · Danbury, TXBuilt 2014 · S/N 602-1247N5083MLakeview Aviation Inc · Sanborn, NDBuilt 1996 · S/N 602-0406N5085QScl Aviators · Wilmington, DEBuilt 1997 · S/N 402B-1047N5086HCavanaugh Flying Service Inc · Minden, NEBuilt 1998 · S/N 602-0504N508DGOld River Flying Service LLC · Wabash, ARBuilt 2013 · S/N 802A-0499N5091HLake Air Service LLC · Jennings, LABuilt 1997 · S/N 602-0444N50927Prairie Ag Service LLC · Des Arc, ARBuilt 1997 · S/N 402A-1041N5094HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 802A-0067N5096YHangar 8 Spray Service LLC · Clark, SDBuilt 1997 · S/N 602-0463N509ZPNeal Aircraft Inc · Slaton, TXBuilt 2021 · S/N 802A-0931N5110SChoctaw Flying Service Inc · Inverness, MSBuilt 1997 · S/N 402A-1043N5110ZPonderosa Airtankers LLC · Safford, AZBuilt 1998 · S/N 802A-0060N5111ABasin Aviation Inc · Rio Oso, CABuilt 1997 · S/N 602-0427N5120EC & L Holzwarth Inc · Virden, ILBuilt 1998 · S/N 402B-1052N5123UR & D Leasing Inc · Lemoore, CABuilt 1997 · S/N 802A-0053N5124PIndependent Dusting Service Inc · El Campo, TXBuilt 1998 · S/N 402A-1051N5128NBasin Aviation Inc · Rio Oso, CABuilt 1998 · S/N 402A-1054N512LAWestern Pilot Service Inc · League City, TXBuilt 2009 · S/N 802A-0312N5144DKeo Ag Service Inc · Keo, ARBuilt 1998 · S/N 802A-0062N514FAAir Tractor Inc · Olney, TXS/N 802A-1334N5166JFitchs Flying Service LLC · Pearsall, TXS/N 602-0510N5175BMiller Aviation Inc · Norton, KSBuilt 1998 · S/N 402B-1084N5175VHound Dog Enterprises LLC · Terre Haute, INBuilt 1998 · S/N 602-0509N51771Air Kraft Spraying Inc · Timber Lake, SDS/N 602-0508N5182BFirst State Ag Air Inc · Viola, DEBuilt 1998 · S/N 602-0524N5185ERoberson James L · New Braunfels, TXBuilt 1998 · S/N 602-0522N5185KBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 602-0521N5189RWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 602-0525N5191BBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 402A-1094N5192FJohnson Airspray Inc · Argyle, MNBuilt 1999 · S/N 402A-1093N5192TAero Applications Inc · Burley, IDS/N 602-0527N519CKAgwerx Aviation Inc · Yuma, COBuilt 2025 · S/N 802A-1183N5202XBoair Inc · Merigold, MSS/N 602-0544N521BFBs Flying Service LLC · Middletown, DEBuilt 2020 · S/N 602-1313N522BFBs Flying Service LLC · Middletown, DEBuilt 2022 · S/N 602-1333N522LAWallin Michael · Walnut Ridge, ARBuilt 2015 · S/N 802A-0622N522LLRegenald Michaud Aviation LLC · Willows, CABuilt 2013 · S/N 802-0532N523BFPadgett Ag Rotors LLC · Missoula, MTBuilt 2017 · S/N 802A-0689N523RBAnderson Interests LLC · East Bernard, TXBuilt 2014 · S/N 802A-0575N526FAAir Tractor Inc · Olney, TXS/N 802A-1338N5272TIndependent Dusting Service Inc · El Campo, TXBuilt 2022 · S/N 402B-1469
Back to AD 2002-19-10