OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,961

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:87-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:87-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.

N385CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0111N3885GRichland Aviation Inc · Sidney, MTBuilt 1976 · S/N 340A0220N388SPWeber Donald E · Saint David, AZS/N 340-0337N38CJAirplane Seven LLC · Watkins, COBuilt 1978 · S/N 402C0023N38CMSale Reported · Fay-Aux-LogesSale reportedBuilt 1979 · S/N 340A0901N38FE239 Lear LLC · Dover, DES/N 340-0096N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829N38LPN38lp LLC · Jacksonville, FLBuilt 1977 · S/N 414-0960N3908CMccreery Aviation Co Inc · Mcallen, TXBuilt 1976 · S/N 421C0136N3911GGunderson Mark H · Reno, NVS/N 340A0230N3912GAllen Byron · Friendswood, TXS/N 340A0231N391ERegistration Pending · Dodge City, KSRegistration pendingBuilt 1960 · S/N 39131N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145N3922CN3922c LLC · Dover, DEBuilt 1977 · S/N 421C0419N3923CSwope Aviation LLC · Elizabethtown, KYBuilt 1976 · S/N 421C0147N3926GSellman Richard L · Missoula, MTS/N 340A0236N3936GBaker George G · Junction City, ORBuilt 1976 · S/N 340A0237N3938GHaverlock Aircraft LLC · Richmond Heights, OHS/N 340A0239N393MPDutch Indian Air LLC · Riverdale, CABuilt 1976 · S/N 421C0203N3959GUniversal Aviation LLC · Decatur, ARS/N 340A0243N3960GLubard Stephen C · Woodland Hills, CAS/N 340A0244N3963GKohsel Aviation LLC · Holland, MIS/N 340A0246N3968GWatkins Aviation LLC · Golden Valley, MNBuilt 1977 · S/N 421C0422N3980GGoods Thomas Jr · Romulus, MIS/N 340A0252N3981GSilver David S · Brookings, ORS/N 340A0253N3983GBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 340A0255N398PGeorge Monte C · Ashland, ORBuilt 1966 · S/N 320D0106N3995AMccoy Keith · Salt Rock, WVBuilt 1978 · S/N 310R1347N3999SViking Aviation LLC · Kindred, NDBuilt 1978 · S/N 310R1292N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246N39HCTherapy Air LLC · Midland, TXS/N 414-0469N39WHGolden Touch LLC · Kalispell, MTBuilt 1976 · S/N 421C0070N3DJHatch Hyrum G · Chandler, AZS/N 421C0011N3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeBuilt 1970 · S/N 414-0056N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525N3HKInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340-0538N3HNDraper Floyd Lawrence · El Paso, TXBuilt 1967 · S/N 310L-0166N3KXMarathon California Holdings Lp · San Diego, CABuilt 1971 · S/N 414-0161N3LNAllen Jeffrey W · Crestwood, KYBuilt 1973 · S/N 340-0301N3PMEwing John L Jr · Yuma, AZBuilt 1967 · S/N 310N-0009N3TQAbove Blue Line LLC · Austin, TXBuilt 1973 · S/N 310Q0752N3VACook Marvin R · Portales, NMS/N 414-0258N3VBHarrison Ted W · Grapevine, TXBuilt 1965 · S/N 320D0044N3VJMiasnikowicz Victor · Lancaster, PABuilt 1973 · S/N 310Q0746N3WFFolk Wolfgang · Fairfield, CABuilt 1975 · S/N 414-0617N4000JThomas Harold C · Fall River Mills, CABuilt 1960 · S/N 39134N400APZoie Air LLC · Fort Lauderdale, FLBuilt 1974 · S/N 340-0345N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510N400BJAirrich LLC · Largo, FLBuilt 1974 · S/N 421B0819
Back to AD 87-21-02 R1