AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N9210MHahn David · Port Lavaca, TXBuilt 1991 · S/N 11067CN9210SBazemore Dennis A · Ingleside, TXBuilt 1975 · S/N MC-384N9210VHarrison Joe · Atlanta, TXS/N 690044N92115Stanger Joseph E · Willow, AKBuilt 2021 · S/N 8967N9211CClark Michael J · Grapevine, TXBuilt 2004 · S/N 81579N9211JBrown Herbert R · Halls, TNBuilt 1966 · S/N 28-3280N9211MSowers James Dalton · Park City, KYBuilt 1966 · S/N 3435N9211VMorrissey Thomas A · Peachtree City, GABuilt 1969 · S/N 690047N9211ZSchacht Michael A · Torrance, CAS/N PHV-2N9212JJones Greg E · Thomasville, GABuilt 1966 · S/N 28-3281N9212LSmith Randall G · Salem, ORBuilt 1971 · S/N AA1A-0112N9212VKocher Edward A · Longview, TXBuilt 1969 · S/N 690057N92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYBuilt 1973 · S/N 17261546N9213JRegistered aircraftBuilt 1966 · S/N 28-3283N9213KCarver Clarence K · Lutz, FLBuilt 1976 · S/N 28-7625170N9213YCarty Eric · Anchorage, AKBuilt 1971 · S/N 18-8918N92140Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1981 · S/N 15285371N92141High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17261549N9214ATerhune Larry W · Saginaw, TXBuilt 1982 · S/N 38-82A0116N9214JSale Reported · Hurdsfield, NDSale reported, pending cancellationBuilt 1966 · S/N 28-3284N9214SC&L Aviation LLC · New London, WIBuilt 1975 · S/N M-1737N9214VGostomski Michael J · Yacolt, WABuilt 1969 · S/N 690049N92159Buster Aviation LLC · Harveys Lake, PABuilt 1973 · S/N 17261550N9215JGrizzard Shawn C · Hayden, IDS/N 28-3285N9215LDipietro Ian · Westfield, MABuilt 1971 · S/N AA1A-0115N9215SGarner James L DBA · Pelham, ALBuilt 1973 · S/N M1711N9215VGonzalez Cruz · North Las Vegas, NVS/N 690045N92161Skywarrior Flight Training Inc · Pensacola, FLBuilt 1973 · S/N 17261551N92169Welch William Ben · Danville, ILBuilt 1973 · S/N 17261553N9216DBlackbird Aviation LLC · Bedford, PABuilt 1958 · S/N 22-6276N9216HBurgess Alan P · Corona, CABuilt 1975 · S/N 17266020N9216JSantana Alexandre C · Long Beach, CABuilt 1966 · S/N 28-3286N9216LLawrence Guy A · Bakersfield, CAS/N AA1A-0116N9216MLewellen Richard H · Mount Vernon, WABuilt 1966 · S/N 3437N9216NSligh Mark G · Cantil, CABuilt 1968 · S/N 67-16865N9216TLudwigson Joel · Inver Grove Hts, MNBuilt 1978 · S/N 38-78A0279N9217DBischoff Danielle I · Palmer, AKBuilt 1958 · S/N 22-6277N9217JWaicekauskas Joe · Raymondville, MOBuilt 1966 · S/N 28-3287N9217KR & R Air Inc · Wilmington, DEBuilt 1976 · S/N 28-7615183N9217MMullenbach Arnold D · Tucson, AZBuilt 1966 · S/N 3438N9217TRegistered aircraftBuilt 1991 · S/N 14020CN9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1988 · S/N 2841022N9218DMaestas Jonathan M · Wright City, MOBuilt 1958 · S/N 22-6278N9218RFishe Flying Corp · Vero Beach, FLBuilt 1988 · S/N 2841023N9218SSurette Phillip · Vail, COBuilt 2021 · S/N 72354N9218VTerrell Aviation Inc · Terrell, TXBuilt 1969 · S/N 690051N92194Ace Aeromotive Inc · Miami, FLS/N 16635N9219HKful Flyers Foundation Inc · Fullerton, CABuilt 1975 · S/N 17266021N9219KJones Robert M · Brooksville, FLBuilt 1976 · S/N 28-7690229N9219LHart Gene E · Ridgecrest, CABuilt 1971 · S/N AA1A-0119
Back to AD 90-04-06 R1