AD 2002-11-03

Registered aircraft · 502

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-11-03')
    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-11-03')
  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.

N2003BBrylen 502 LLC · Dumas, TXBuilt 2011 · S/N 502A-2741N2019PAgricultural Air Services LLC · Jupiter, FLBuilt 2011 · S/N 502B-2792N2022YPinecliff Aerial Inc · Camilla, GABuilt 2011 · S/N 502B-2760N2032KKing Ag Leasing Inc · Sudan, TXBuilt 2011 · S/N 502B-2749N2035EGibson Flying Service Inc · Marianna, ARBuilt 2011 · S/N 502B-2791N2038QAt402 LLC · Banquete, TXBuilt 2013 · S/N 502B-2878N2040EWeaver Flying Service Inc · Quincy, WABuilt 2011 · S/N 502B-2743N2045GOught 9 LLC · East Helena, MTBuilt 2012 · S/N 502B-2820N20527Tr Flying Service LLC · Milan, MNBuilt 2012 · S/N 502B-2798N205CGSeewald Jeffrey W · Great Bend, KSBuilt 2006 · S/N 502A-2603N205RMLissie Flying Service Inc · Lissie, TXBuilt 1998 · S/N 502A-0491N2066EEdwards Flying Service Inc · Leland, MSBuilt 2012 · S/N 502B-2826N208VVT&T Highcountry Flying Service LLC · Saint Anthony, IDS/N 502B-0560N2094MCmk Aerial Inc · Sutton, NEBuilt 2011 · S/N 502B-2756N226DHCottonwing Air LLC · Indianola, MSBuilt 2010 · S/N 502B-2726N243LAH & G Farms Inc · Corcoran, CABuilt 2015 · S/N 502B-3020N244PWAdams Aerial Solutions LLC · Decatur, ILBuilt 2024 · S/N 502A-3494N246BRRoberts Ag Air Service Inc · Lamoure, NDBuilt 2012 · S/N 502B-2786N247LFWilliamsburg Air Service Inc · Kingstree, SCBuilt 2022 · S/N 502A-3395N249LABank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 502A-3049N252LABas Part Sales LLC · Greeley, COBuilt 1994 · S/N 502B0252N254LAObriens Flying Service Inc · Iowa, LABuilt 2016 · S/N 502A-3054N256MSBuck N Aviation Inc · Fort Worth, TXNon-citizen corporation, flight hours not reportedBuilt 2021 · S/N 502A-3281N261JBJb Leasing LLC · Norfolk, NEBuilt 2012 · S/N 502B-2813N268TWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2010 · S/N 502B-2727N270TWMattern Rodney M DBA · Dawson, NDBuilt 2022 · S/N 502A-3367N272LAB & D Aircraft Leasing LLC · Waupun, WIBuilt 2018 · S/N 502B-3145N273GCO'Briens Flying Service Inc · Iowa, LABuilt 2016 · S/N 502A-3073N275ATBoardman Air Service LLC · Henderson, NEBuilt 2025 · S/N 502A-3597N275JAGibbs Aviation Inc · Fremont, OHBuilt 2011 · S/N 502B-2755N277LAA & M Flying Service Inc · Carlisle, ARBuilt 2011 · S/N 502B-2777N282XPProp Ag LLC · Montezuma, KSBuilt 2025 · S/N 502A-3573N289JARiceland Aviation Inc · Jennings, LABuilt 2012 · S/N 502B-2809N290LAAscend Ag Inc · Wall, SDBuilt 2018 · S/N 502A-3137N297FAWalhalla Ag Service LLC · Walhalla, NDBuilt 2014 · S/N 502B-2973N3025PDakota Air Spray LLC · Huron, SDBuilt 2013 · S/N 502B-2896N302PCAerial Crop Protection Inc · Belle Glade, FLBuilt 2020 · S/N 502B-3267N30411Farm Air Inc · Astoria, ILBuilt 2014 · S/N 502B-2914N30523R & R Flight Service Inc · Mendota, ILBuilt 2013 · S/N 502B-2934N30539Midwest Aerial Spraying LLC · Dorchester, NEBuilt 2013 · S/N 502B-2936N3063HBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 502B-2943N3066VMurtagh Flying Service Inc · Lexington, MSBuilt 2014 · S/N 502B-2965N3067WMg37 Investments LLC · Holdrege, NEBuilt 2014 · S/N 502B-2977N3071KAurora Cooperative Elevator Co · Aurora, NEBuilt 2015 · S/N 502B-3014N3071WWood Flying Inc · Panhandle, TXBuilt 2014 · S/N 502B-3009N3072FGreat Plains Application LLC · Slayton, MNBuilt 2014 · S/N 502B-2999N3073CCentral Plains Spraying Inc · Hart, TXBuilt 2014 · S/N 502B-3015N3074FDeterding James L DBA · Pond Creek, OKBuilt 2014 · S/N 502B-3006N3075D49 Flying Service LLC · Greenwood, MSBuilt 2015 · S/N 502B-3016N3076HPost Rock Aviation Inc · Lincoln, KSBuilt 2015 · S/N 502B-3017
Back to AD 2002-11-03