AD 94-20-04 R2

Registered aircraft · 4,469

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:94-20-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
  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.

N28LDDancing Bear LLC · Polson, MTBuilt 1970 · S/N D-9205N28SGMarshall Robert W · Hemet, CABuilt 1956 · S/N D-4540N28WBMulder Air Inc · Renville, MNBuilt 1968 · S/N D-8729N2904BPricer J Richard · Arlington, TXBuilt 1953 · S/N D-3549N2907BPowell Gregory S · Paso Robles, CAS/N D-3552N2910BShively Aurora J · Anchorage, AKS/N D-3554N2917BPyle Dana · Naples, FLBuilt 1953 · S/N D-3558N291ABSerafini Louis · Ringwood, NJBuilt 1970 · S/N D-9119N2921BMurray Michael E · Fallbrook, CABuilt 1964 · S/N D-7372N2924BBonanza N2924b LLC · Hermann, MOBuilt 1953 · S/N D-3565N2929BRegistered aircraftBuilt 1953 · S/N D-3570N2930BMcdougall Angus D · Gillette, WYBuilt 1953 · S/N D-3571N2931BMake It So LLC · Knoxville, TNBuilt 1953 · S/N D-3572N2942BThomas Ronald G · Dallas, TXBuilt 1953 · S/N D-3583N2944BVantreese Kenneth C · Tulsa, OKBuilt 1953 · S/N D-3585N2949BKlassen Lloyd G · Enid, OKBuilt 1953 · S/N D-3590N2950BReichert Thomas W · Dickinson, NDBuilt 1956 · S/N D-3591N2952BReardon Michael · East Falmouth, MABuilt 1953 · S/N D-3593N2954BO'Conell David DBA · Butte, MTBuilt 1953 · S/N D-3595N2960FNaber Tania B · Niceville, FLBuilt 1953 · S/N D-3601N2962BBridges Janiece · Forsyth, MOS/N D-3603N2969BBlaszak Benjamin D · Troy, MIBuilt 1953 · S/N D-3610N2970BRymer Joseph M · Riverview, FLBuilt 1953 · S/N D-3611N2971BParker Michael T Trustee · Denton, TXBuilt 1953 · S/N D-3612N2972BTowle Karl E · Denton, TXBuilt 1954 · S/N D-3935N2973BLightle Theodore L · Cocoa, FLBuilt 1953 · S/N D-3613N2975BHayes Jack D · Kingman, AZBuilt 1953 · S/N D-3615N2976BParker Michael T Trustee · Denton, TXBuilt 1956 · S/N D-4786N2977BFilippelli Kenneth J · Edmond, OKBuilt 1955 · S/N D-4152N2978BDelarosa Kelly · Port Orange, FLBuilt 1953 · S/N D-3618N2980AWest David R · Newalla, OKBuilt 1978 · S/N D-10154N2981BStowells Outlaw Services LLC · Rigby, IDS/N D-3621N2983BFisher Bryce Anthony · Cleveland, TNS/N D-3623N2986BBrittian Scott A · Wichita, KSBuilt 1953 · S/N D-3496N2993BHillegeist Tracy · Beverly, KSBuilt 1953 · S/N D-3631N2995BLeggat Douglas J · Manhattan, KSBuilt 1953 · S/N D-3633N2996BSale Reported · Alton, ILSale reportedBuilt 1953 · S/N D-3634N2997BFigueroa Christopher · West Covina, CABuilt 1953 · S/N D-3635N2999BNordhagen Melvin L · Spokane, WABuilt 1954 · S/N D-3748N29DCDwlg Aviation LLC · Rogers, ARBuilt 1965 · S/N D-7943N29VRegistered aircraftBuilt 1972 · S/N D-9340N2CBBoxman LLC · Wilmington, DEBuilt 1977 · S/N D-10090N2CSBolton Geoffrey M · Groveland, CABuilt 1973 · S/N D-9463N2DCGottsleben John J · Tucson, AZBuilt 1964 · S/N D-7318N2DNHaines Matthew E · Lake Dallas, TXBuilt 1973 · S/N D-9426N2DRGustafson Dale H · Kingwood, TXBuilt 1962 · S/N D-6924N2DURegistered aircraftBuilt 1977 · S/N D-10030N2EYBender Jeffrey T · Scottsdale, AZBuilt 1967 · S/N D-8401N2GRRichardson Gordon B II · Caldwell, TXBuilt 1961 · S/N D-6659N2JXBrookeash Inc · Waxahachie, TXBuilt 1965 · S/N D-7811
Back to AD 94-20-04 R2