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.

N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094N295DDJds Flying Service Inc · Glen Allan, MSBuilt 2018 · S/N 602-1295N298LAGregs Crop Care Co Inc · Wilbur, WABuilt 2011 · S/N 802A-0398N3011SH & H Flying Co · Finley, TNBuilt 2013 · S/N 402B-1276N3017ZPlane LLC (The) · Grove, OKBuilt 2013 · S/N 602-1223N3030CWtas LLC · Dyersburg, TNBuilt 2013 · S/N 402B-1283N3030LShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2015 · S/N 802A-0602N3030QFinke Aviation LLC · Charleston, MSBuilt 2013 · S/N 802A-0509N3033HAkbj LLC · Lewes, DEBuilt 2013 · S/N 802A-0507N3038AMoss Jimmy David DBA · Tillar, ARBuilt 2013 · S/N 602-1229N3038PAgri-Tech Aviation Inc · Indianola, IABuilt 2013 · S/N 402B-1284N3042SAg Aviation Inc · Muleshoe, TXBuilt 2013 · S/N 802A-0520N3044FIowa On The Fly Inc · Fonda, IABuilt 2013 · S/N 602-1231N3054WMoes Crop Dusting Service Inc · Marysville, CABuilt 2013 · S/N 802A-0525N30562J & D Aircraft LLC · Larimore, NDBuilt 2013 · S/N 602-1235N3056QPalmer Flying Service Inc · Manito, ILBuilt 2013 · S/N 802A-0535N3059NIowa On The Fly · Fonda, IABuilt 2013 · S/N 602-1236N305LAShores Ag-Air Inc · Corpus Christi, TXBuilt 2014 · S/N 402B-1305N3063GChristmas Flying Service LLC · Shelby, MSBuilt 2013 · S/N 802A-0529N3063YWeaver Flying Service Inc · Quincy, WABuilt 2013 · S/N 802A-0524N3065TCarroll Flying Service Inc · Lake Providence, LABuilt 2014 · S/N 602-1239N3066LBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 802A-0549N3066NBoair Inc · Shaw, MSBuilt 2014 · S/N 602-1241N30674Jlw Aviation Inc · Carlisle, ARBuilt 2014 · S/N 802A-0557N30676Michaelis Gary DBA · Goodwin, ARBuilt 2014 · S/N 802A-0573N3067JHartley Flying Service Inc · Stuttgart, ARBuilt 2014 · S/N 802A-0554N3068BMccreary Flying Service LLC · Clarksdale, MSBuilt 2014 · S/N 602-1248N3069SRoma Air Corp · Belle Glade, FLBuilt 2014 · S/N 802A-0559N3070EG B Aerial Applications Inc · Slaton, TXBuilt 2014 · S/N 802A-0551N3070FDakota Air Spray LLC · Huron, SDBuilt 2014 · S/N 802A-0577N3070GWilliamsburg Air Service Inc · Kingstree, SCBuilt 2013 · S/N 402B-1303N3070N49 Flying Service LLC · Greenwood, MSBuilt 2014 · S/N 602-1250N3072YAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0588N30757Moses Lake-Warden Air Service Inc · Moses Lake, WABuilt 2013 · S/N 802A-0534N3079DNesom Waddell Cole · New Roads, LABuilt 2015 · S/N 602-1260N307BRRice Flying LLC · Poplar Bluff, MOFirst renewal noticeBuilt 2017 · S/N 802-0718N3082PCustom Air Inc · Roe, ARBuilt 2015 · S/N 802A-0600N3082VMid Missouri Spray Service LLC · Richmond, MOBuilt 2015 · S/N 802A-0620N3083KBoyds Aviation LLC · Rayville, LABuilt 2015 · S/N 802A-0618N3083RAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0627N3085QAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0628N3086AArrow Aviation Inc · Broken Bow, NEBuilt 2015 · S/N 802A-0616N3087KBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 602-1264N309PFPalmer Flying Service Inc · Manito, ILBuilt 2025 · S/N 802A-1213N310KPLowry Flying Service Inc · Grinnell, IABuilt 2013 · S/N 602-1232N312FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2020 · S/N 602-1312N313FAAg Air Flying Service Inc · Toppenish, WABuilt 2016 · S/N 802A-0655N316LAAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1316N319HCThree Flying Monkeys LLC · Sunray, TXBuilt 2017 · S/N 602-1286N321DASherer Robert O · Deadwood, SDBuilt 1991 · S/N 402A-0814
Back to AD 2002-19-10