AD 2002-11-05

Registered aircraft · 948

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-05')
    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-05')
  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.

N3066LBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 802A-0549N30674Jlw 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-0554N3069SRoma 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-1303N3072YAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0588N30757Moses Lake-Warden Air Service Inc · Moses Lake, WABuilt 2013 · S/N 802A-0534N307BRRice 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-0616N309PFPalmer Flying Service Inc · Manito, ILBuilt 2025 · S/N 802A-1213N313FAAg Air Flying Service Inc · Toppenish, WABuilt 2016 · S/N 802A-0655N3160QAg Cat Applicators LLC · Avoca, TXBuilt 1982 · S/N 400-0477N31626James Richard W · Chowchilla, CABuilt 1983 · S/N 400-0511N3164BL & L Flying Inc · Glen Allan, MSBuilt 1984 · S/N 400-0513N3166YDixie Crop Care Inc · Dixie, GABuilt 1984 · S/N 400-0515N316LAAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1316N321DASherer Robert O · Deadwood, SDBuilt 1991 · S/N 402A-0814N324BSB&S Air Inc · Lumpkin, GABuilt 2025 · S/N 802A-1189N325BMFarm Air Service Inc · Tallulah, LABuilt 2003 · S/N 802A-0144N329LAWells Flying Services LLC · Holdrege, NES/N 802A-0345N332ATAg Solutions LLC · Satanta, KSBuilt 1999 · S/N 802A-0087N332BSHog Air Aviation Inc · Paragould, ARBuilt 2019 · S/N 802A-0791N333BRB&R Aerial Crop Care Inc · Connell, WABuilt 2022 · S/N 802A-0989N334BSMitchell Andrew D Trustee · Winnie, TXS/N 802A-0521N335BSOld River Flying Service LLC · Helena, ARBuilt 2016 · S/N 802A-0643N335LAAir Tractor Inc · Olney, TXS/N 802-1335N335QFBearcreek Flying Service LLC · Oakes, NDBuilt 2013 · S/N 802A-0522N339BSB & S Air Inc · Lumpkin, GABuilt 2020 · S/N 802A-0839N340LATri-Air Farms LLC · Mamou, LABuilt 2009 · S/N 802A-0349N344VAAir Tractor Inc · Olney, TXS/N 802A-1344N347BMAir Tractor Inc · Olney, TXS/N 802A-1347N347ERO'Briens Flying Service Inc · Iowa, LABuilt 2022 · S/N 802A-0944N347REAir Tractor Inc · Olney, TXS/N 802A-1331N349ASAero Applicators Inc · Sterling, COBuilt 2015 · S/N 802A-0603N350DAAir Tractor Inc · Olney, TXS/N 802A-1354N354FSAnderson Interests LLC · East Bernard, TXBuilt 2010 · S/N 802A-0355N358ASNew Frontier Aviation LLC · Fort Benton, MTBuilt 2015 · S/N 802A-0604N363ATAeronautical Technologies Inc · Clovis, NMBuilt 2013 · S/N 802A-0508N363GSParrish Aerial Services LLC · Wilmington, DEBuilt 2015 · S/N 802-0587N3652ZCotton Ag Inc · Walters, OKBuilt 1980 · S/N 400-0256N3654GDixie Flying Service Inc · Bradley, ARS/N 400-0281N3655TPutz Gary D · Hearne, TXS/N 301-0300
Back to AD 2002-11-05