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.

N7902WHicks Mark T · Newark, CABuilt 1964 · S/N 28-1931N7903CHocking Valley Flying Club Inc · Hebron, OHBuilt 1975 · S/N 28R-7635121N7904CVaught Jon M · Stillwater, OKBuilt 1976 · S/N 28-7610064N7904WRobins Steven W · Franklinton, LAS/N 28-1934N7907WRegistration Pending · El Prado, NMRegistration pending, canceledBuilt 1964 · S/N 28-1937N7908WEmerald Coast Flying Club LLC · Fort Walton Beach, FLBuilt 1964 · S/N 28-1939N7909WCircus Of Six LLC · Wilmington, DEBuilt 1964 · S/N 28-1942N790FBEagle Aviation LLC · Fishers, INBuilt 2025 · S/N 28020212N790UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020169N790YAB & T Aviators Inc · Wantagh, NYBuilt 1967 · S/N 28-23668N7911NRynearson Mark J · Wolcott, NYBuilt 1969 · S/N 28-5323N7911WSandidge Richard A · Pueblo, COBuilt 1964 · S/N 28-1944N7913NStamps David R · Sparta, TNBuilt 1969 · S/N 28-5325N7913WStream Aviation LLC · Luther, OKBuilt 1964 · S/N 28-1946N7914NTeeters Gregory R · Bossier City, LABuilt 1969 · S/N 28-5326N7914WInstrument Trainer Flying Club Inc · Champaign, ILBuilt 1964 · S/N 28-1947N7917WRoss Eric L · Peoria, AZS/N 28-1953N7919NLa Grassa William W · Sacramento, CABuilt 1969 · S/N 28-5330N7919WFarabee Mechanical Inc · Hickman, NEBuilt 1964 · S/N 28-1956N791CRPryll Gary · Cape Coral, FLBuilt 1980 · S/N 28-8090259N791DAFox Norman A · Maryville, TNBuilt 1969 · S/N 28-25848N791LNieves Oscar A · Carolina, PRBuilt 1969 · S/N 28-26078N7920NN7920n LLC · Sioux Falls, SDBuilt 1969 · S/N 28-5331N7920WJb III LLC · Stuart, FLBuilt 1964 · S/N 28-1957N7921NBolin Paul C · Vancouver, WABuilt 1969 · S/N 28-5332N7922NMemo Air Services LLC · San Antonio, TXBuilt 1969 · S/N 28-5333N7922WVouk Frank E · Firth, IDBuilt 1964 · S/N 28-1960N7923NGcc Aviation LLC · Elberton, GABuilt 1969 · S/N 28-5334N7924WStumpner Van H · Warsaw, MOBuilt 1964 · S/N 28-1963N7927WFlight 4 U LLC · Lakeport, CABuilt 1964 · S/N 28-1967N7928CCash Management Consulting LLC · Granite Springs, NYBuilt 1975 · S/N 28-7625088N7929WStevenson Robert F · Wilmington, DEBuilt 1964 · S/N 28-1970N792AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843795N7930FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7715248N7930NMerrill Erich W III · Corvallis, ORBuilt 1969 · S/N 28-5341N7930WFleenor Robert S · Scottsburg, INBuilt 1964 · S/N 28-1971N7931NScott Lindbloom · Ft Wright, KYBuilt 1969 · S/N 28-5342N7932NMyers Richard J · Lebanon, TNBuilt 1969 · S/N 28-5343N7932WBlaine Richard A Jr · Boardman, OHBuilt 1964 · S/N 28-1973N7933CLaytham Ricky A · Coatesville, PAS/N 28-7690090N7933NCc Aero Services LLC · Bullard, TXBuilt 1969 · S/N 28-5344N7934WAir Roanoke Ltd · Roanoke, VABuilt 1964 · S/N 28-1975N7935CRfc Inc · Hiawatha, IABuilt 1975 · S/N 28R-7635122N7935NTorrington Flying Club Inc · Torrington, WYBuilt 1969 · S/N 28-5347N7935WRather Be Flying LLC · New Castle, DEBuilt 1964 · S/N 28-1976N7936WHiller Jeron P · Marshfield, WIBuilt 1964 · S/N 28-1978N7937WYang Zhongyi Deroll · Oro Valley, AZBuilt 1964 · S/N 28-1979N7938CVolar Corp · El Cajon, CABuilt 1979 · S/N 28-7916428N7938WPiper Club LLC · Atkinson, NEBuilt 1964 · S/N 28-1980N7939NOrama Jorge H · Fort Myers, FLBuilt 1969 · S/N 28-5351
Back to AD 87-08-08 R3