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.

N2061LRoth Aerial Spraying LLC · Milford, NEBuilt 2012 · S/N 602-1216N2064JPadgett 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-0207N209LAWest Valley Aviation Inc · Five Points, CABuilt 2011 · S/N 802A-0409N211CHRegistered aircraftS/N 802A-1278N212DTThiel Aircare Inc · Chowchilla, CABuilt 2005 · S/N 802A-0212N212FBAero Spray Inc DBA · Appleton, MNBuilt 2010 · S/N 802A-0368N213BHBighorn Flying Co LLC · Wood River, NEBuilt 2013 · S/N 402B-1279N214RLLassco LLC · Middletown, DEBuilt 2021 · S/N 802-0896N216TATailwinds Air Inc · Morganza, LABuilt 2013 · S/N 602-1227N224CNRegistered aircraftBuilt 2020 · S/N 802A-0843N226FBLipan Creek Flying Service LLC · Eola, TXBuilt 2024 · S/N 802A-1157N228DTGibbs Aviation Inc · Fremont, OHBuilt 2021 · S/N 602-1315N228RGA+ Aviation Services LLC · Garden City, KSBuilt 2009 · S/N 402B-1223N22FKFast Ag Air LLC · Watertown, SDBuilt 2022 · S/N 802-0965N22WHAeronautical Technologies Inc · Clovis, NMBuilt 1997 · S/N 802A0039N2394RPalmer Flying Service Inc · Manito, ILBuilt 1999 · S/N 602-0545N23WTAeronautical Technologies Inc · Clovis, NMBuilt 2014 · S/N 802-0568N240DLBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2011 · S/N 402B-1240N240LATwin Cities Aviation Inc · Yuba City, CABuilt 2010 · S/N 802A-0375N244LAWoodline Aviation LLC · Memphis, MOBuilt 2014 · S/N 602-1244N246LAChambers County · Anahuac, TXBuilt 2018 · S/N 402B-1400N247SEThiel Air Care Inc · Chowchilla, CABuilt 2012 · S/N 802A-0444N257CAHorizon Air LLC · Lumpkin, GABuilt 2025 · S/N 802-1185N257MSNeal Aircraft Inc · Slaton, TXBuilt 2023 · S/N 602-1350N258LACrop First Aviation Inc · Stanfield, AZBuilt 2015 · S/N 602-1257N259LAC & L Holzwarth Inc · Virden, ILBuilt 2015 · S/N 602-1265N2602MWoodley Aerial Leasing · Walnut, ILBuilt 2002 · S/N 602-0645N260LAGibbs Aviation Inc · Fremont, OHBuilt 2016 · S/N 602-1268N263LACmk Aerial Inc · Sutton, NEBuilt 2015 · S/N 602-1263N265FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 802A-1265N268FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2026 · S/N 802A-1268N271LAA+ Aviation Services LLC · Goodland, KSBuilt 2012 · S/N 802A-0471N272DAAero Spray Inc DBA · Appleton, MNBuilt 2025 · S/N 802-1258N274ATBoardman Air Service LLC · Henderson, NEBuilt 2012 · S/N 402B-1251N274BMEvergreen Flying Service Inc · Dover, DEBuilt 2026 · S/N 802A-1274N276ATBoardman Air Service LLC · Henderson, NEBuilt 2024 · S/N 802A-1110N277ATBoardman Air Service LLC · Henderson, NEBuilt 2016 · S/N 602-1277N278ATBoardman Air Service LLC · Henderson, NEBuilt 2022 · S/N 802A-0953N281DLThisius Flying Service Llp · Wells, MNBuilt 2013 · S/N 402B-1281N281LABoedeker Flying Service East LLC · Childress, TXBuilt 2008 · S/N 402B-1201N282LAProp Ag LLC · Montezuma, KSBuilt 2012 · S/N 602-1215N288KWFarm Air Inc · Astoria, ILS/N 802A-1288N291DLNorthstar Aero Spray Inc · Clara City, MNBuilt 2008 · S/N 402B-1199
Back to AD 2002-19-10