OpenAirDocs.org
AD 87-11-01 R1

Registered aircraft · 630

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

N4865VWoltjer Richard J · Pennock, MNBuilt 1968 · S/N 30110N4876VGrothe Loren L · Willmar, MNBuilt 1968 · S/N 30118N4880VVillage Motors Inc · Lake Village, INS/N 30122N4887VJennings Delbert Keith · West Fargo, NDBuilt 1968 · S/N 30128N4888VBarrett James Michael · Concordia, KSBuilt 1967 · S/N 30065N4892VPonto Michael A · Edgewood, NMBuilt 1968 · S/N 30131N4915VPegasus Aviation LLC · Rogersville, MOS/N 30139N492TCMckinley Matthew · Sault Sainte Marie, MIBuilt 1971 · S/N 30362N4941VClark Robert J · Brookshire, TXS/N 30146N4946VJennings Carl M · Au Gres, MIS/N 30148N495RFStewart Delbert G · Kent, OHBuilt 1973 · S/N 73-30613N501CRTarno Suzzan · Avondale, AZBuilt 1973 · S/N 73-30607N505JWCampbell Matthew P · Visalia, CABuilt 1975 · S/N 75-31118N51LHAlger David W · Lago Vista, TXS/N 98-301027N53CWBeitel Theodore C · Higden, ARBuilt 1996 · S/N 96-301024N5683UMccarver Tyler L · Wharton, TXS/N 73-30500N575JHDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1975 · S/N 75-30791N577BLLee Bryan Steven · Lubbock, TXBuilt 1973 · S/N 74-30648N579SVTorrey Daniel B · Santa Paula, CABuilt 1979 · S/N 79-30952N57DYClair William E Jr · Casper, WYBuilt 1978 · S/N 78-30867N6007VHauser Scott · Towanda, PABuilt 1971 · S/N 31024N611DCWhite John D · Rockwall, TXS/N 79-30942N617JMTravland Christopher · Austin, TXBuilt 1976 · S/N 76-30845N623AMMelgar Albert T · El Paso, TXBuilt 1979 · S/N 79-30928N625RLPerry James Edward · Cleveland, GABuilt 1979 · S/N 79-30960N63026Hacker Jr Delbert M · Granbury, TXBuilt 1984 · S/N 84-30989N6302XGelaude James J · Lakewood, COS/N 84-30988N63083Kearney Charles B III · Argyle, TXBuilt 1984 · S/N 84-30992N6312YSellers Mark R · Philadelphia, PAS/N 85-30993N6314ZWilliam T Murphy Investigations Inc · Stillwater, MNBuilt 1985 · S/N 85-30996N6315VGiroux Michael J · Trophy Club, TXBuilt 1985 · S/N 85-30995N6316VGardoski Mark · Dayton, NVS/N 87-30998N6385HEds Used Machinery LLC · Memphis, MOS/N 30104N6556VGiannola Peter S · San Diego, CAS/N 32-15N6559VDodson International Parts Inc · Rantoul, KSBuilt 1969 · S/N 30248N6566VRiley Shawn P · Saint Paul, MNBuilt 1969 · S/N 30252N6570VHildreth Jay · Wamego, KSBuilt 1969 · S/N 30257N6574VHandke Robert C · Atchison, KSBuilt 1969 · S/N 30250N6575VGreeson Albert O · Moscow, KSBuilt 1970 · S/N 32-22N6578VPence Dale E · Richmond, MOS/N 31005N6580VStassen Andrew R · Concord, CABuilt 1969 · S/N 32-16N6582VMonroe Robert Sean · Oceanside, CABuilt 1969 · S/N 30256N6583VLedger William V Jr · Shreveport, LABuilt 1969 · S/N 32-20N6588VIsom Stephen R · Eagle, COBuilt 1970 · S/N 30265N6591VEpic Air Power LLC · Newark, DES/N 32-29N6597VGold Air LLC · Woodland Hills, CABuilt 1970 · S/N 32-24N65JKAmerican Aircraft & Marine LLC · Indianapolis, INBuilt 1973 · S/N 74-30641N6600VLeahy Thomas J · Marblehead, OHBuilt 1970 · S/N 30261N6601VJofredo Corp · Zephyrhills, FLBuilt 1970 · S/N 30294N6603VCmbb Enterprises LLC · Plainview, TXBuilt 1970 · S/N 30275
Back to AD 87-11-01 R1