OpenAirDocs.org
AD 90-13-01 R1

Registered aircraft · 1,150

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-13-01-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-13-01-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.

N31079Top Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1991 · S/N 51526N3107WWeyerhaeuser Nr Co · Seattle, WABuilt 1991 · S/N 51512N311AEAir Evac Ems Inc · O Fallon, MOS/N 45572N311FValley River Leasing Inc · Murphy, NCBuilt 1974 · S/N 1354N312JPTomlinson Aviation Inc · Ormond Beach, FLS/N 4580N312NLYellowstone Wr Ranch LLC · Dillon, MTBuilt 1990 · S/N 51409N313APWav Series LLC · Batavia, ILBuilt 1981 · S/N 3471N313DHRogers Helicopters Inc · Fresno, CABuilt 1981 · S/N 45630N313HPMshr Helicopter Services LLC · Chehalis, WABuilt 1990 · S/N 51341N313MBSri Sky LLC · Madison, WIBuilt 1980 · S/N 3001N315AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45482N315MHCane Helicopter Services LLC · Franklin, LABuilt 1981 · S/N 45692N315RDDc Leasing LLC · Cedar Falls, IABuilt 1979 · S/N 2852N315WCAnjum Mohammad A · Melrose Park, ILBuilt 1991 · S/N 51465N316CFLeading Edge Flight Academy LLC · Bend, ORBuilt 1977 · S/N 2264N316RCHelicopter Emergency Lift Program · Pomona, NYBuilt 1974 · S/N 1268N316SPSan Juan Aviation LLC · Wilmington, DEBuilt 1983 · S/N 45768N316TVAero Products · Show Low, AZBuilt 1979 · S/N 2704N3172COlson Marine Inc · Ward Cove, AKS/N 3669N3173HAlabama Law Enforcement Agency · Montgomery, ALBuilt 1982 · S/N 45714N3176LRiggs Bobby W · Lake Mary, FLBuilt 1983 · S/N 45648N317JPTomlinson Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 4563N3180LGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 51055N3184PMarks Lloyd · Lafayette, LAS/N 45774N3188PMarks Aviation Group LLC · Lafayette, LABuilt 1983 · S/N 45778N3188ZFulton County Police Headquarters · Atlanta, GABuilt 1985 · S/N 3860N318AEAir Evac Ems Inc · O Fallon, MOBuilt 1985 · S/N 51160N3190PVeturis David · Lake Forest, CABuilt 1983 · S/N 45779N3192G3192 Golf Inc · Wauchula, FLBuilt 1972 · S/N 809N3196GUSA Helicopter Inc · West Winfield, NYBuilt 1972 · S/N 775N31ATHelicopter Leasing Inc · Coral Gables, FLBuilt 1972 · S/N 918N3202DPapa Mike Aviation LLC · Dousman, WIBuilt 1985 · S/N 3849N3202QDavid Lee Aircraft Sales And Leasing LLC · Wilmington, DEBuilt 1986 · S/N 3938N320CMDyvig Enteprises LLC · Northwood, IABuilt 1972 · S/N 836N3211NTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1984 · S/N 3808N321AHBektor III LLC · Kalispell, MTBuilt 1984 · S/N 51100N322ECDivesa Aviation Services LLC · Missoula, MTBuilt 1977 · S/N 2218N322NBlue Sky LLC · Anchorage, AKS/N 1507N324CMClarke Environmental Mosquito Management · Roselle, ILBuilt 1977 · S/N 2303N327AEAir Evac Ems Inc · O Fallon, MOBuilt 1990 · S/N 51365N32AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45327N32KYEnglish Air Service LLC · Santa Maria, CABuilt 1979 · S/N 2875N331MHKt Auburndale LLC · Panama City Beach, FLBuilt 1982 · S/N 3564N332MHXtreme Aviation LLC · Falkville, ALBuilt 1980 · S/N 2958N333EROrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45203N333FCGolden Ranch Aviation Inc · Raceland, LABuilt 1975 · S/N 1763N333LWBohica Consulting Service Of Nevada Inc · Boulder City, NVBuilt 1980 · S/N 2932N334AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51326N334KCHawk Hollow Farm LLC · Brighton, MIBuilt 1994 · S/N 4303N335DMSmith Steven Lee · Whitehall, MTBuilt 1981 · S/N 3330
Back to AD 90-13-01 R1