OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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.

N217AWHobart Aviation Inc · Akron, OHS/N 28-7125332N217LFSnyder Aero LLC · Joshua, TXBuilt 1969 · S/N 32-1157N217LMCanada Christopher W · Freeport, FLBuilt 1966 · S/N 28-21972N217TXLong Jeffrey E · Dothan, ALBuilt 1997 · S/N 3246070N217VASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3257492N21802Owen Michael C · Seaside, CABuilt 1978 · S/N 28-7990059N21803Morgan Edward · Gaithersburg, MDBuilt 1978 · S/N 28-7990060N2180EInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28-7916165N2180FGentle Breezes LLC · Johnson City, TNBuilt 1978 · S/N 32-7940012N2180KRoad Runner Flying Club Inc · Radcliffe, IABuilt 1978 · S/N 28-7911082N2180RRoan Paul J · Clive, IABuilt 1969 · S/N 28-5479N2180TDe Bella Richard M Sr · Blackwood, NJBuilt 1971 · S/N 28-7205027N2180YAstro Aviation LLC · Cross Plains, TNBuilt 1979 · S/N 28-7990383N2180ZM&M Aero LLC · Wilmington, DEBuilt 1979 · S/N 32-7940102N2181BJao Robert V · Kailua, HIBuilt 1978 · S/N 28-7916114N2181TAdk Flying Club Inc · Ballston Spa, NYBuilt 1971 · S/N 28-7205036N21825Shepherd David K J · Bakersfield, CABuilt 1978 · S/N 32-7840189N2182BFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990124N2182QCassett Terry D · Mankato, MNBuilt 1979 · S/N 28-7990297N2182TGabrick Steven J · Hickory Valley, TNS/N 28-7205037N2182VJavorsek Daniel II · Harriman, TNS/N 32R-7987117N21836C & S Development Services LLC · Weatherford, TXBuilt 1978 · S/N 32R-7885263N2183DLyons Terry L · Springfield, ILBuilt 1978 · S/N 28-7990163N2183KMaven Aviation LLC · Dillon, MTBuilt 1978 · S/N 32-7940022N2183MHayes William F · Philomath, ORBuilt 1979 · S/N 28-7911088N2183TSkies Unlimited LLC · Clinton Township, MIBuilt 1971 · S/N 28-7205026N2183VMile High Maintanance Inc · Lakewood, COBuilt 1979 · S/N 32R-7987118N2183ZCondor Enterprises Inc · Elkins Park, PABuilt 1979 · S/N 32-7940105N2184BPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7990125N2184DMeyer David J · Granbury, TXBuilt 1978 · S/N 32R-7985032N2184TFisher Global LLC · Conway, ARBuilt 1971 · S/N 28-7205028N21857Top Air · Salt Lake City, UTBuilt 1978 · S/N 28-7990062N2185BHeirborne Again LLC · West Bridgewater, MABuilt 1978 · S/N 28-7990126N2185GGateway Flying Club Inc · Blaine, MNBuilt 1978 · S/N 32R-7985044N2185KVandermeulen Jeffrey A · Pioneer, CABuilt 1978 · S/N 32R-7985061N2185XHendricks Robert H · Chico, CABuilt 1979 · S/N 28-7990366N21866Donthineni Rakesh · Oakland, CABuilt 1978 · S/N 28-7990063N2186THutchins Christopher E · Venice, FLBuilt 1971 · S/N 28-7205038N21870Tezaguic-Swanson Olga I · Wichita Falls, TXBuilt 1978 · S/N 28R-7837309N21873Orourke Daryl J · Oak Lawn, ILBuilt 1978 · S/N 32R-7885264N2187TRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1971 · S/N 28-7205039N2187UFearneyhough Jack M · Gilbertsville, KYBuilt 1979 · S/N 32-7940059N2188RN2188r LLC · Pittsburgh, PABuilt 1969 · S/N 28-5481N21892Dove Aviation LLC · Greensboro, GABuilt 1978 · S/N 32R-7887237N21899Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 32R-7887239N2189NFlight Operations Academy LLC · Chandler, AZBuilt 1979 · S/N 28R-7931050N2189QBlue Hen Aviation Services LLC · Easton, PABuilt 1979 · S/N 28-7990298N2189RSchrage James A · Danville, INBuilt 1969 · S/N 28-5482N2189TTulsa Aviation Group Leasing LLC · Claremore, OKBuilt 1971 · S/N 28-7205041N2189ZWeltin Gregory G · Kennebunk, MEBuilt 1981 · S/N 28-8190285
Back to AD 87-08-08 R3