OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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-08-08-R3')
    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-08-08-R3')
  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.

N6654WKosko Stanley G · Seattle, WABuilt 1965 · S/N 28-21279N6655JLaukkanen Heikki J · Camas, WABuilt 1968 · S/N 28-5139N6655W5b Aviation LLC · Duncan, OKS/N 28-20757N6656JFauber Clifford W · Cincinnati, OHBuilt 1968 · S/N 28-5141N6657JRegistration Pending · Tavares, FLRegistration pendingS/N 28-5142N6657WKlienstuber James D · Yamhill, ORBuilt 1965 · S/N 28-20760N6659JDuffey Albert J · Clover, VABuilt 1968 · S/N 28-5146N6659WJeffrey Franklin B · Suisun City, CABuilt 1965 · S/N 28-20762N665DPPflum David R · Roscommon, MIBuilt 1970 · S/N 28-5817N6661WGoing To Rome LLC · Valley Center, KSS/N 28-20764N6664WN6664w LLC · Grand Prairie, TXBuilt 1965 · S/N 28-21281N6666JGhormley James G · Arlington, TXBuilt 1968 · S/N 28-24352N6666WReed Phillip G · Troy, TNBuilt 1965 · S/N 28-20770N6667FTrident Aircraft Inc · Easton, MDBuilt 1976 · S/N 28-7715174N6669WSeiler Brent L · Burton, TXBuilt 1965 · S/N 28-20774N666CDRegistered aircraftBuilt 1982 · S/N 28-8390022N666FLWoodhouse Ashley T · Sylmar, CABuilt 1971 · S/N 28-7125589N6670WHighland Asset Management · Auburn, CABuilt 1965 · S/N 28-20775N6671JRotor And Wing LLC · Tioga, NDBuilt 1968 · S/N 28-24357N6671WSessions Max R · Moody, ALS/N 28-21282N6673JMoody Edward L Jr · Candler, NCBuilt 1968 · S/N 28-24359N6673WCk Nickels Inc · Muleshoe, TXBuilt 1965 · S/N 28-20780N6675JReece Aviation LLC · North Clarendon, VTBuilt 1968 · S/N 28-24362N6676JRozof Chester F · Fort Myers, FLBuilt 1968 · S/N 28-24363N6676WWorkman Industries Inc · Durant, IABuilt 1965 · S/N 28-20783N6677WOsgood Darrell F · Watervliet, MIBuilt 1965 · S/N 28-20784N6678FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715175N6678JWiener Ronald K · Tucson, AZBuilt 1968 · S/N 28-24365N6678WMadison Andrew J · Inver Grove, MNS/N 28-20786N667CHBorders Darin · Center, TXBuilt 1978 · S/N 32R-7887191N667DTGinter Jon A · Marlton, NJBuilt 1972 · S/N 28-7310026N667LBChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843932N667RHN667rh LLC · Oakdale, NYBuilt 2002 · S/N 3257290N667SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881435N6680JElliott Bryn · Blue Point, NYS/N 28-24368N6684WWaltman Richard Dean · Moses Lake, WAFirst renewal noticeBuilt 1965 · S/N 28-20790N6685WZulueta David · Louisville, GAS/N 28-20791N6687JRio Creek Aviators Ltd · Casco, WIBuilt 1968 · S/N 28-24377N6687WHolland William A · Brownwood, TXBuilt 1965 · S/N 28-20794N6688WArkansas Air Expeditions And Instruction LLC · Greenbrier, ARBuilt 1965 · S/N 28-20795N6689WStoll Jared M · Burnt Hills, NYBuilt 1965 · S/N 28-20796N668MAJohnson Saquane · Sunderland, MDBuilt 2000 · S/N 3246168N6690JJones Michael A · Chateaugay, NYBuilt 1968 · S/N 28-24380N6691WN6691w LLC · Nazareth, PABuilt 1965 · S/N 28-20799N6693JOgrady Thomas · Franklin Square, NYS/N 28-24385N6694JStegemoller Adam Dean · Lewisville, TXBuilt 1968 · S/N 28-24387N6694WKhan Mohammed Sabir K · Sugar Land, TXBuilt 1965 · S/N 28-20802N6695JMorgan Jonathan · East Troy, WIS/N 28-24388N6695WMeyers Chris · Andrews, TXS/N 28-20804N6696JTattersall Stewart Trustee · Minden, NVBuilt 1968 · S/N 28-24389
Back to AD 87-08-08 R3