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.

N404NEFehlhaber Wolfgang M · Port Orange, FLBuilt 1981 · S/N 404-0857N404NSJ + D Aviation Services LLC · Centerville, MABuilt 1980 · S/N 402C0421N404PJPrivate Jet LLC · Miami Springs, FLBuilt 1981 · S/N 402C0513N4051CSky High Ventures LLC · Bartlett, TNBuilt 1980 · S/N 340A0995N4057CAberdeen Flying Service · Aberdeen, SDBuilt 1982 · S/N 414A0848N4062ACessna 310n4062a LLC · Tuscaloosa, ALBuilt 1978 · S/N 310R1362N4063QThin Air Inc · Hays, KSBuilt 1973 · S/N 310Q0724N4065GCruz-Alvarez Raul Trustee · Miami Springs, FLS/N 340A0268N406BKN406bk LLC · Nantucket, MABuilt 1984 · S/N 402C0807N406GAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0329N406RCIsland Flights Inc · Wilmington, DEBuilt 1981 · S/N 402C0470N4070LDesert Air LLC · Hagerman, NMBuilt 1968 · S/N 421-0070N4074LEminent Technology · Tallahassee, FLBuilt 1968 · S/N 421-0074N4076QSandoval Juan · Valley Stream, NYBuilt 1968 · S/N 401-0176N4078QGerker Carl J · Palmdale, CAS/N 320C0046N4079CCalled To Care Residential Facility LLC · Avondale, AZBuilt 1978 · S/N 310R1364N407RKMoore John C · San Miguel, CABuilt 1968 · S/N 401-0181N4090ATop Gun Aviation Group Inc · Santa Monica, CABuilt 1978 · S/N 310R1368N4091GRobinson Brant Fitzgerald · Powder Springs, GABuilt 1977 · S/N 340A0275N409BKHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0651N40GBSlb Enterprises LLC · Newark, DEBuilt 1977 · S/N 340A0264N40JCDbs Aviation LLC · Sulphur Springs, TXBuilt 1973 · S/N 421B0384N40MEUnlimited Boat Sales Inc · Page, AZS/N 421C1241N40NYJohnson Elite International LLC · Tucson, AZBuilt 1970 · S/N 414-0160N40RUMoore Terry Alexander Trustee · Adel, GABuilt 1980 · S/N 421C0878N40SKSides Family Management LLC · El Paso, TXBuilt 1979 · S/N 414A0323N40SSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 340A0650N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576N41085421 Bravo LLC · Marine City, MIS/N 421B0440N4108QStuckle Gary W · Davenport, WABuilt 1967 · S/N 310N-0008N410AJSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 421C1093N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422N410NFMurphy Aviation Inc · Gilroy, CABuilt 1978 · S/N 414A0102N410WMFlying Life LLC · Middleburg, FLBuilt 1975 · S/N 310R0578N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458N41124Wenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1973 · S/N 421B0465N4116GAcaats LLC · Queen Creek, AZBuilt 1977 · S/N 340A0288N411ABAmerican Time Machine LLC · Edmond, OKBuilt 1980 · S/N 414A0524N411CKFairchild Bill R · Dalhart, TXS/N 421C0229N411DCWillert Fred J · San Diego, CABuilt 1965 · S/N 411-0135N411GCadwell Bradley L · Orlando, FLBuilt 1964 · S/N 310I0125N411MZSongbird Air LLC · Lakewood, COBuilt 1980 · S/N 421C1002N411STwin Adventures LLC · Cincinnati, OHBuilt 1972 · S/N 340-0099N411SMKonkel Bernard · Kalispell, MTBuilt 1978 · S/N 310R1404N411TBLewis Nathan · North Plains, ORS/N 421B0481N411VTvc Aviation Inc · Lebanon, OHBuilt 1973 · S/N 340-0250N411VGMontala Investments LLC · Montgomery, ALBuilt 1981 · S/N 414A0675
Back to AD 87-21-02 R1