OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,242

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:89-24-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:89-24-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.

N9109MAr Malibu LLC · Gassville, ARBuilt 1985 · S/N 46-8608006N910MFly By Night Aviation LLC · San Francisco, CABuilt 1979 · S/N 310R1653N910RHDelaurentis Robert · Oak Harbor, WABuilt 1984 · S/N 46-8408066N9111PBas Part Sales LLC · Greeley, COBuilt 1987 · S/N 4608084N9113ZKenmore Crew Leasing Inc Owner Trustee · Bellingham, WABuilt 1986 · S/N 4608045N9114NOutlier Mt LLC · Kalispell, MTBuilt 1986 · S/N 4608048N9117JBlue Skies Malibu LLC · San Diego, CABuilt 1987 · S/N 4608052N91183Hatch Hyrum G · Gilbert, AZBuilt 1969 · S/N 20700106N9120YEast West Aviation LLC · Joaquin, TXBuilt 1985 · S/N 46-8608010N9121XCarter Associates Inc · Burr Oak, MIBuilt 1987 · S/N 4608094N9122LBerman Joshua E · Nashua, NHBuilt 1987 · S/N 4608096N9122NAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1987 · S/N 4608097N9122YCook Auction Co Inc · Clinton, MOBuilt 1985 · S/N 46-8608011N9123VEschenbach Ralph F · Woodside, CAS/N 4608060N9124YAerobox LLC · Seattle, WABuilt 1985 · S/N 46-8608012N9125BStockton Aviation Group LLC · Stockton, CABuilt 1987 · S/N 4608068N9125YKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N U20603324N9127ZPalmy LLC · Lander, WYBuilt 1987 · S/N 4608059N912WTNew Tech Construction LLC · Wilmington, DEBuilt 1977 · S/N 340A0353N9131XWomack Equipment Leasing LLC · Terre Haute, INBuilt 1987 · S/N 4608083N9133GConsolidated Consulting Inc · Norfolk, NEBuilt 1988 · S/N 4608111N9133VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1988 · S/N 4608112N913SEHill Capital Leasing LLC · Phoenix, AZBuilt 1978 · S/N P21000038N9146RZoll Ross H · Glen Allen, VABuilt 1988 · S/N 4608138N915Ramsey Brent C · Tulsa, OKBuilt 1980 · S/N 340A0910N9167MMalibu Rising LLC · Phoenix, AZBuilt 1986 · S/N 46-8608025N916JWSouth Delta Aviation Inc · Fayetteville, ARBuilt 1976 · S/N TJ-91N916MD43701 Corp · Zanesville, OHBuilt 1981 · S/N 310R2133N917WCBarr Air Patrol LLC · Mesquite, TXBuilt 1973 · S/N U20602032N9186TEpi Technologies Inc · Antioch, ILBuilt 1977 · S/N 21062227N919CBCatclaw Aviation LLC · San Antonio, TXBuilt 1981 · S/N 414A0672N919FAFortnum Air LLC · Dana Point, CAS/N 414A0628N919HWStonehollow Pain Services LLC · Elizabeth, ARS/N 21060054N919PJDel Rosso Peter · Los Angeles, CABuilt 1981 · S/N TK-140N91DDLonghorn Leasing LLC · Anchorage, AKS/N EA-511N91SDFlying High LLC · Plainfield, ILBuilt 1986 · S/N 4608035N91TWPistol Aviation LLC · Stillwater, OKBuilt 1978 · S/N 414A0117N920CBOgden Newspapers Inc · Wheeling, WVBuilt 1981 · S/N TJ-380N920GGAbbott Air Inc · Hydro, OKBuilt 1976 · S/N 21061545N920NZAltura Aviation 3-Nz LLC · Waxhaw, NCS/N P21000309N9219T19tango LLC · Newport Beach, CAS/N 46-8608015N921AJAerohippo Corp · Franklin Lakes, NJBuilt 1974 · S/N 421B0613N921KARay Aviation LLC · Carmel, INBuilt 1984 · S/N 340A1803N921ZF Michael Schultz LLC · Coleman, TXBuilt 1986 · S/N 251079N9221MMiller Aviation Properties LLC · Abilene, KSBuilt 1985 · S/N 46-8608017N922ASSchool Of Missionary Aviation Technology · Ionia, MIS/N 414-0033N922MATeton Leasing LLC · Pocatello, IDBuilt 1976 · S/N U20603467N923EC333 Ranch LLC · Elko, NVBuilt 1977 · S/N 21062299N925RCCastle Shelter Group LLC · Clearwater, MNBuilt 1969 · S/N D-9001N925TPKtm Projects LLC · Durant, OKBuilt 1976 · S/N TJ-35
Back to AD 89-24-01 R1