AD 81-21-02 R1

Registered aircraft · 366

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:81-21-02-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-21-02-R1')
  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.

N7162LAnderson Abruzzo Intl Balloon Museum Foundation · Albuquerque, NMBuilt 1996 · S/N S60A-3216N71679Sun Flyer Balloon LLC · Albuquerque, NMBuilt 1996 · S/N S55A-3074N7171HAir America Promotions Inc · Deltona, FLS/N S60A-3220N7172YGwin Corey J · Hot Springs, SDS/N RX7-3321N721USMiller Howard G Jr · Atmore, ALBuilt 1997 · S/N S60A-3233N74RSKuehlmuss Michael · Whately, MABuilt 1975 · S/N S55A-233N74TNGallegos Frank L · Los Lunas, NMS/N S50A-231N77820Arkwell Kathy A · Peoria, ILBuilt 1994 · S/N RX7-3304N783TPNilz R Patrick · Tucson, AZS/N S60A-232N79FATiffin Aire Inc · Tiffin, OHS/N S55A-507N79UWBrittingham Carl H · Rochester, MIBuilt 1979 · S/N S55A-519N87RAJones Cameron D · Statesboro, GABuilt 1987 · S/N S60A-3064N88DCBorts Wyman L Jr · Des Moines, IAS/N S55A-3018N89TLDream Chasers Balloon Team LLC · Palm City, FLS/N S60A-3113N90002Fantasy Balloon Flights Inc · Port Jervis, NYBuilt 1992 · S/N S66A-3049N9005WSanderson Alan R · Albany, ORBuilt 1992 · S/N RX7-3265N9006XGordon Mary E · East Canton, OHBuilt 1992 · S/N RX7-3267N90096Schindele Michael D · Tolna, NDFirst renewal noticeS/N RX7-3266N9024QBims Balloon Bonanza LLC · Neshanic Station, NJS/N S55A-3076N9029ZMonahan Todd J · Queensbury, NYBuilt 1992 · S/N RX7-3270N9032JH I Flight Inc · Lexington, KYBuilt 1992 · S/N S66A-3051N9037GKetchner Vickie N · Wellsville, NYS/N RX7-3273N9038ZPersonal Investment And Managed Properties LLC · Catawissa, MOBuilt 1992 · S/N RX7-3274N9043VBulkley James C · Harveys Lake, PAFirst renewal noticeBuilt 1997 · S/N S50A-3004N90448South Taft Liquor Inc · Fort Collins, COBuilt 1992 · S/N S55A-3062N9047QCowan Melissa G · Nicholasville, KYBuilt 1998 · S/N RX7-3328N904GGH I Flight Inc · Lexington, KYS/N S60A-3232N90593Harden Jesse R · Colorado Springs, COS/N RX7-3277N9060YSpacious Skies Lc · Cedar City, UTBuilt 1992 · S/N RX7-3278N9064HBalloon Quest Inc · Fenton, MIBuilt 1993 · S/N S60A-3182N9066DShane Micheal P · North Ogden, UTS/N RX7-3323N90701Balcom Lina V · Milton, VTBuilt 1995 · S/N RX7-3308N9077GNj Tech Medics LLC · Neshanic Station, NJBuilt 1993 · S/N S60A-3184N90861Cheatham Laurie · La Verne, CABuilt 1997 · S/N RX7-3324N90952Bennett James S · Louisville, KYBuilt 1993 · S/N RX7-3283N90954Smith William N · Canton, OHBuilt 1993 · S/N S60A-3186N9096ABiernacki Buzz · Albuquerque, NMBuilt 1993 · S/N S60A-3189N9105E605 Balloon Ride LLC · Sioux Falls, SDBuilt 1998 · S/N S60A-3242N91081Sturge Gregory R · Tulsa, OKS/N RX6-3003N9121KJohnson Robb C · Council Bluffs, IABuilt 1998 · S/N RX7-3325N9124JDrennan Benjamin B · Cordele, GAS/N S55A-3077N9126KSee Glenn M · Albuquerque, NMBuilt 1998 · S/N RX7-3326N91339Forrest Services LLC · Dayton, NVBuilt 1998 · S/N S60A-3251N9133NBost Randall D · Arkadelphia, ARBuilt 1998 · S/N RX7-3327N9139ECato Amie D · Commerce, TXBuilt 2007 · S/N RX7-3348N9139VPrairie Sky Inc · Custer, SDBuilt 1998 · S/N RX7-3329N9146CBallooning Society Of Pikes Peak · Colorado Springs, COBuilt 1998 · S/N RX7-3330N9146SNusz Hannah · Durango, COBuilt 1998 · S/N RX7-3331N9175UBalloonacy LLC · Fayetteville, GABuilt 1994 · S/N RX7-3291N91764Christianson Brian P · Glenburn, NDBuilt 1994 · S/N RX7-3295
Back to AD 81-21-02 R1