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.

N3076WRba LLC · Kimberly, IDBuilt 2015 · S/N 502B-3024N3078TBarts Flying Service Inc · Storm Lake, IABuilt 2015 · S/N 502B-3027N30832Bank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2015 · S/N 502B-3039N312LARoth Aerial Spraying LLC · Milford, NEBuilt 2015 · S/N 502B-3022N313TWWiebe Aerial Applications LLC · Whitewater, KSBuilt 2013 · S/N 502B-2890N316WRHoxie Sprayers Inc · Hoxie, KSBuilt 1995 · S/N 502A-0316N319LACrop Air LLC · Eaton, COBuilt 2015 · S/N 502B-3019N321ATBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 502B-2746N321GAHoppe Air LLC · Beaman, IAS/N 502-0069N326LAMurtagh Flying Service Inc · Lexington, MSBuilt 2018 · S/N 502A-3126N329BRHorizon Air LLC · Lumpkin, GABuilt 2008 · S/N 502B-2633N329KHDixie Air Applicators LLC · Itta Bena, MSBuilt 2018 · S/N 502B-3132N329RSolace Aerial LLC · Walnut Hill, FLBuilt 2007 · S/N 502B-2614N332LAHoran Spraying LLC · Plainview, TXBuilt 2019 · S/N 502A-3188N334LASun Valley Dusting Co · San Benito, TXBuilt 2019 · S/N 502B-3187N337MAMeyers Aerial Service LLC · Superior, NEBuilt 2014 · S/N 502B-3010N341LALake Washington Flying Service Inc · Glen Allan, MSBuilt 2022 · S/N 502B-3341N3636BAir Tractor Inc · Olney, TXBuilt 2026 · S/N 502B-3636N369AB3rd Gen Aviation LLC · Lisbon, NDBuilt 2008 · S/N 502B-2653N371LABruton Aerial Spraying Inc · Garden City, TXBuilt 2018 · S/N 502A-3177N373HDHinkle Air Spray Inc · Cavalier, NDBuilt 2001 · S/N 502B-0636N377LAFickes Aerial & Ag Services LLC · Norfolk, NEBuilt 1996 · S/N 502B-0377N394LAAerial Solutions Of Tennessee LLC · Milan, TNBuilt 1994 · S/N 502B-0242N407CTCrosswind Aviation LLC · Port Barre, LAS/N 502-0076N4109XSky Apply LLC · Hector, MNS/N 502B2602N410LASunnyside Aero Inc · Schlater, MSBuilt 2020 · S/N 502B-3238N411BFNorhtstar Aerospray Inc · Clara City, MNBuilt 2017 · S/N 502A-3082N412KHAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2012 · S/N 502B-2822N41340Twist Air LLC · Earle, ARS/N 502B-2599N4155PAndersons Flying Service Inc · Robbins, CABuilt 2008 · S/N 502B-2629N41608Higgins Leasing Inc · Spring, TXBuilt 2007 · S/N 502B-2613N41612Puryear Rodney K · Pampa, TXBuilt 2007 · S/N 502B-2612N41675Registration Pending · Cavalier, NDRegistration pendingBuilt 2008 · S/N 502B-2650N41854Alpha Ag Air LLC · Little River, KSBuilt 2008 · S/N 502B-2624N41991Bravo Gildardo F · Mission, TXBuilt 2008 · S/N 502B-2623N4200SWood Flying Inc · Panhandle, TXBuilt 2008 · S/N 502B2625N42086Beta Ag Inc · Ralls, TXBuilt 2008 · S/N 502B-2637N42190Matecumbe Flying Service Inc · Immokalee, FLS/N 502B-2705N421CAD&D Aerial LLC · Gratiot, WIBuilt 2009 · S/N 502B-2672N4220WRegistered aircraftBuilt 2010 · S/N 502B-2696N4223GTowe Flying Service · Madison, ALBuilt 2009 · S/N 502B-2675N425BFBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2014 · S/N 502B-3018N438RJSunflower Aero Inc · Atwood, KSBuilt 1996 · S/N 502A-0345N439PSTlb Air Llp · Grafton, NDBuilt 2023 · S/N 502A-3426N443LARubbert Jan · Upham, NDS/N 502A-3143N445MSAas LLC · Ovid, MIBuilt 1994 · S/N 502B-0237N45019Aerial Solutions Of Tennessee LLC · Milan, TNBuilt 1990 · S/N 502-0090N4501QConfederate Air Inc · Mcgehee, ARS/N 502-0086N4509STall Towers Ag Service Inc · Page, NDBuilt 1990 · S/N 502-0088N45113Over And Under Flying Service Inc DBA · Knox, INBuilt 1990 · S/N 502-0094
Back to AD 2002-11-03