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.

N8809VBlue Rocket LLC · Kalispell, MTBuilt 1971 · S/N 30343N8811VHoke Thomas R · Ashland, ORBuilt 1971 · S/N 30349N8812VBeers Jason A · Girard, OHBuilt 1971 · S/N 30352N8813VCrosby David · Potomac, MDBuilt 1971 · S/N 30378N8820VDiversified Dialysis Services Inc · Lithonia, GABuilt 1971 · S/N 32-35N8822JSwyryn Alexander Douglas · Cape Coral, FLBuilt 1973 · S/N 73-30606N8825VPosey Robert L · Newport Beach, CAS/N 30366N8826VBush Edward L · Bainbridge, GABuilt 1971 · S/N 30347N8828VStebner William R · Crossville, TNBuilt 1971 · S/N 32-40N8833VMeyr Richard J · Reno, NVBuilt 1971 · S/N 32-46N8836VEast Robert W · Vancouver, WABuilt 1971 · S/N 32-42N8840VN8840v LLC · Longmont, COBuilt 1971 · S/N 30377N8843VHamstra Siebe · Chandler, AZBuilt 1971 · S/N 30367N8847VZollars Thomas B · Dallas, TXBuilt 1971 · S/N 30359N8854VBadenhope John R · Greeneville, TNBuilt 1971 · S/N 30380N8858VDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1971 · S/N 30382N8861VAyres Sean E · Lompoc, CABuilt 1971 · S/N 30392N8862VInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31022N8864VAnthony Baruth · Saint Joseph, MOBuilt 1971 · S/N 32-48N8867RWamego William O · Glenpool, OKBuilt 1962 · S/N 4229N8868VWard Steven E · Wilbur, WABuilt 1972 · S/N 32-62N8869VShackelford Jody L · Cherokee Village, ARBuilt 1971 · S/N 30383N8870VOklahoma Historical Steam Engine Museum Foundation · Oklahoma City, OKS/N 32-52N8871VLavelle Aircraft LLC · Berrien Springs, MIBuilt 1972 · S/N 30427N8876VBlackburn Aviation Air LLC · Mesa, AZS/N 32-50N89ELHorner James G · Santa Clara, CABuilt 1989 · S/N 89-301009N8CMHoover C Michael · Spring Hill, FLBuilt 1970 · S/N 32-26N900MMTickle Randal W · Roanoke, VABuilt 1973 · S/N 73-30602N910EJNoble John E · New Kent, VABuilt 1971 · S/N 30405N910STRegistration Pending · Beebe, ARRegistration pendingBuilt 1988 · S/N 88-30999N911RMSooner City Properties LLC · Dover, DES/N 31030N91CESchwartz Stacy L · Windsor, NYBuilt 1969 · S/N 30206N91JTHoran Raj · Plainview, TXBuilt 1991 · S/N 91-301014N93486Ablamis Roger · Los Gatos, CABuilt 1973 · S/N 73-31062N93505Clark Roger D · Lubbock, TXBuilt 1973 · S/N 73-32-120N93518Chisun Robert W · Shallowater, TXBuilt 1973 · S/N 73-30588N93535Northbase LLC · Columbus, MSBuilt 1973 · S/N 73-30567N93537Mccarver Tyler L · Blessing, TXBuilt 1973 · S/N 73-30599N93541Gibbs Frederick L · Flagstaff, AZBuilt 1973 · S/N 73-32-126N93546Jackson Bob K · Bay City, TXS/N 74-30669N93547Sharp Randon · Amarillo, TXBuilt 1973 · S/N 73-30594N93548Holloway Donald P · Chino Hills, CABuilt 1974 · S/N 74-30698N93549Stephens Nicholas C · Overgaard, AZS/N 74-30624N93554Pittman Randy L · Morris, ILBuilt 1973 · S/N 74-31074N93563Mdn Industries · Forsyth, MTBuilt 1973 · S/N 73-30597N93570Huffaker Kenneth Scott · Post, TXBuilt 1973 · S/N 73-32-116N93586Malacara Erasmo F · Edinburg, TXBuilt 1973 · S/N 73-30612N93591Pischl John · Yorkville, ILBuilt 1973 · S/N 73-30593N93600Babcock Barry B · Monument, COS/N 73-31061N93619Bradberry Charles G · Iowa Park, TXBuilt 1973 · S/N 74-30644
Back to AD 87-11-01 R1