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.

N4217WAviation Flying Service · Greenwood, MSS/N 602-1180N4219MBombero Aviation LLC · Childress, TXBuilt 2007 · S/N 802A-0264N4219WEverett Flying Service Inc · Holly Grove, ARS/N 802A-0334N4219YTri State Aerial LLC · Canton, SDBuilt 2010 · S/N 802A-0352N4221STri Rotor Spray & Chemical · Ulysses, KSBuilt 2008 · S/N 802A-0305N422JCChorman Spraying LLC · Milton, DEBuilt 2018 · S/N 802A-0762N422RDAir-Sprayers Inc · Two Buttes, COBuilt 2009 · S/N 402B-1224N422TWSug-Air LLC · Lubbock, TXBuilt 2016 · S/N 602-1278N4244FOli Grow LLC · Baskin, LABuilt 2009 · S/N 802A-0316N4244PPrairie Ag Service LLC · Des Arc, ARS/N 802A-0308N4247UHiggins Leasing Inc · Woodlands, TXBuilt 2016 · S/N 802-4001N424FSOver And Under Flying Service Inc · Knox, INBuilt 1997 · S/N 602-0424N42505Holloway Air Service Inc · Merigold, MSBuilt 2009 · S/N 602-1178N42590Twin County Air-Ag Inc · Winnie, TXBuilt 2009 · S/N 602-1181N4265DVisser Ag Inc · Rigby, IDBuilt 2007 · S/N 802A-0259N426LAC And C Flying Service Inc · Pocahontas, ARBuilt 2012 · S/N 802A-0441N427AAAero Leasing LLC · Virden, ILS/N 402A-1032N427NSVisser Ag Inc · Rigby, IDBuilt 2003 · S/N 802A-0153N428JJKingrey William S · Richmond, TXBuilt 2014 · S/N 402B-1307N428LAFletcher Flying Service Inc · Roe, ARBuilt 2006 · S/N 802A-0228N42EAEscott Aerial Spraying LLC · El Reno, OKBuilt 2012 · S/N 402B-1269N437VADelta Air Inc · Belzoni, MSBuilt 2014 · S/N 602-1237N438LADownstown Airport Inc · Vineland, NJBuilt 2014 · S/N 602-1238N442MAMeyers Air Service LLC · Superior, NEBuilt 2022 · S/N 602-1337N445HAAir Tractor Inc · Olney, TXBuilt 2016 · S/N 802-0633N448LAAir Kraft Spraying Inc · Timber Lake, SDBuilt 2012 · S/N 802A-0448N45123Wood Flying Inc · Panhandle, TXS/N 402-0753N4512JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2023 · S/N 602-1349N4515JLowry Flying Service Inc · Grinnell, IABuilt 2024 · S/N 602-1380N45196Boettcher Aerial Inc · Beloit, KSS/N 402-0755N4523LWiebe Albert · Seminole, TXS/N 402-0757N4527XSug-Air LLC · Lubbock, TXS/N 402A-0758N4528LSkyworks Aviation LLC · Waynesboro, GAS/N 402A-0759N4532FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0769N45363South Delta Aviation Inc · West Helena, ARS/N 402-0774N4540FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 402-0784N4541SKankakee Valley Aviation LLC · Wanatah, INS/N 402-0778N45469Over & Under Flying Service Inc · Madison, INBuilt 1991 · S/N 402A-0797N45472Rtc Aviation LLC · Munday, TXBuilt 1991 · S/N 402A-0794N4552TMci Leasing LLC · Decatur, ILS/N 402-0750N45553Racer Aviation LLC · Moorestown, NJBuilt 1991 · S/N 402-0818N4555YDevil Dusters Inc · Artesia, NMBuilt 1991 · S/N 402-0812N4556UAir Care Leasing LLC · Lamar, COBuilt 1991 · S/N 402-0815N455PAMcginty Flying Service LLC · Jones, LABuilt 2006 · S/N 602-1141N455RANorrland Partners LLC · Hillsboro, NDBuilt 2024 · S/N 802-1167N4567SBoyle Flying Service Inc · Boyle, MSBuilt 2014 · S/N 802A-0571N456LAJaj Flying LLC · Sutton, NEBuilt 2005 · S/N 602-1131N457ATAeronautical Technologies Inc · Clovis, NMBuilt 2005 · S/N 802A-0201N458RANorrland Partners LLC · Hillsboro, NDBuilt 2025 · S/N 802A-1212N459RASilver Wings Flying Company LLC · Littlerock, WABuilt 2025 · S/N 802A-1243
Back to AD 2002-19-10