AD 2002-26-05

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-26-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-26-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.

N502HCBoyd'S Aviation LLC · Rayville, LABuilt 2009 · S/N 502B-2690N502HDRosewood Air LLC · Plaucheville, LABuilt 2013 · S/N 502B-2899N502HFHowze Flying Services LLC · Banquete, TXBuilt 2023 · S/N 502A-3430N502HMMoores Aerial Applicators LLC · Clinton, NCBuilt 2024 · S/N 502A-3539N502HWNeal Aircraft Inc · Slaton, TXBuilt 2010 · S/N 502B-2695N502JAHoppe Air LLC · Beaman, IABuilt 1992 · S/N 502-0169N502JDDeterding Jim · Pond Creek, OKBuilt 2009 · S/N 502B-2656N502JFLejeune Aerial Applications LLC · Basile, LABuilt 2017 · S/N 502A-3114N502JKRoma Air Corp · Belle Glade, FLBuilt 1996 · S/N 502B-0373N502JPAcadian Dusters LLC · Church Point, LABuilt 1989 · S/N 502-0052N502JRJerrys Flying Service Inc · Wabbaseka, ARS/N 502B-2670N502JWBear Flying Service Inc · Sicily Island, LABuilt 1992 · S/N 502-0163N502KBMeyers Aerial Service LLC · Superior, NEBuilt 2011 · S/N 502B-2748N502KFForest Kevin · Langdon, NDBuilt 2011 · S/N 502B-2745N502KHWillmar Aerial Spraying Inc · Olivia, MNBuilt 2009 · S/N 502B-2666N502KSFoxtrot Air LLC · Highmore, SDBuilt 2009 · S/N 502B-2655N502LCCady Neil DBA · Rock Falls, ILBuilt 2011 · S/N 502B-2790N502LDH & G Farms · Corcoran, CABuilt 2013 · S/N 502B-2905N502LYR & R Flight Service Inc · Mendota, ILBuilt 2015 · S/N 502B-3013N502MBLepanto Crop Service Inc · Lepanto, ARBuilt 2023 · S/N 502B-3418N502MDRba LLC · Kimberly, IDBuilt 2008 · S/N 502B-2654N502MHWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 502-0164N502MKGeist Daniel C · Crookston, MNBuilt 1996 · S/N 502B-0356N502MSMid-State Aviation II Inc · Cozad, NEBuilt 2005 · S/N 502B-2588N502MVMidwest Aerial Spraying LLC · Dorchester, NEBuilt 2008 · S/N 502B-2621N502NBWells Fargo Equipment Finance Inc · Clark, SDBuilt 2012 · S/N 502B-2814N502NEWilcox Aerial Applications Inc · Tilden, NEBuilt 2012 · S/N 502B-2806N502NJBretts Spray Service Inc · Onida, SDBuilt 1991 · S/N 502-0138N502NLBoettcher Aerial Company Inc · Beloit, KSBuilt 2012 · S/N 502B-2837N502NRHoelscher Rodney · San Angelo, TXBuilt 2012 · S/N 502B-2817N502PAPost Rock Aviation Inc · Lincoln, KSBuilt 2012 · S/N 502B-2812N502PBHershey Flying Service Inc · David City, NEBuilt 1998 · S/N 502B-0500N502PVWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2022 · S/N 502A-3355N502QDixie Flying Service Inc · Gilliam, LABuilt 1999 · S/N 502B-0573N502RBDans Flying Service Inc · Crookston, MNBuilt 2010 · S/N 502B-2702N502RCMid-State Avaition II Inc · Cozad, NEBuilt 1996 · S/N 502B-0348N502RER And R Flight Service Inc · Mendota, ILBuilt 2008 · S/N 502B-2626N502RSSwing Wing Inc · Veedersburg, INBuilt 2024 · S/N 502A-3501N502SBGross Flying Service Inc · Larned, KSBuilt 2023 · S/N 502A-3428N502SDTri-County Ag Service Inc · Ipswich, SDBuilt 2015 · S/N 502B-3023N502SEWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2024 · S/N 502A-3486N502SMBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 502A-3186N502SSSchneider Aerial Inc · Rugby, NDBuilt 2023 · S/N 502A-3416N502TGOld River Applicators LLC · Simmesport, LABuilt 1999 · S/N 502B-0538N502TRSterling John A · Port Lavaca, TXBuilt 1999 · S/N 502B-0553N502VBRegistered aircraftBuilt 2013 · S/N 502B-2886N502VSValley Spraying Service LLC · Gann Valley, SDBuilt 2013 · S/N 502B-2889N502WDOver And Under Flying Service DBA · Knox, INBuilt 1995 · S/N 502B0320N502WFBank Of Utah Trustee · Salt Lake City, UTS/N 502B-2646N502XH&G Farms Inc · Corcoran, CABuilt 2023 · S/N 502B-3423
Back to AD 2002-26-05