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.

N2144WHansen Kenneth L · Kimballton, IABuilt 1979 · S/N 28-7916331N21459N21459 LLC · Farmington Hills, MIBuilt 1978 · S/N 32R-7887212N2145MHanscom Afb Aero Club · Hanscom Afb, MAS/N 28R-7837069N2145NRaschio Ernesto G · Miami, FLBuilt 1979 · S/N 32-7940034N21469Blubaugh Patrick S · Inyokern, CABuilt 1978 · S/N 32R-7887214N2146TBreitfelder Nicholas A · Durango, IABuilt 1971 · S/N 28-7125546N2146UHolub Hayden Thomas · Hobbs, NMBuilt 1979 · S/N 28R-7931096N2147DRegistered aircraftBuilt 1978 · S/N 28-7911034N2147GAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 28-7916178N2147JWolfe Stephen D · Richland, WABuilt 1978 · S/N 28R-7931011N2147KAgati Inc · Chicago, ILBuilt 1978 · S/N 32-7940020N2147NN701bt LLC · Carmel, INBuilt 1979 · S/N 32-7940035N2147PStevens Nicholas · Fort Collins, COBuilt 1979 · S/N 32-7940042N2147TSchavone Loren A · Fullerton, CABuilt 1971 · S/N 28-7125547N2147ZScott Jeffery A · Stephenville, TXBuilt 1979 · S/N 28-7921020N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050N2148BKaroudjian David · Savannah, GAS/N 32R-7987030N2148N2 Delta 5 LLC · Oakes, NDBuilt 1979 · S/N 32R-7985069N2148PHorizon Aviation LLC · Buffalo, NYBuilt 1979 · S/N 32-7940043N2148XMckinley John Perry · Amarillo, TXBuilt 1979 · S/N 28R-7931129N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378N21494Dmc Air LLC · West Chester, OHS/N 32R-7887216N21499Kling Clint W · Summerset, SDBuilt 1978 · S/N 32R-7887218N2149DSeaton Brad S · Cache, OKBuilt 1978 · S/N 32R-7985031N2149EPierce Martin H · Big Sky, MTBuilt 1978 · S/N 28-7911044N2149JN2149j LLC · Colorado Springs, COBuilt 1978 · S/N 28-7911061N2149TChandler Air Service Inc · Chandler, AZBuilt 1979 · S/N 28-7911114N2149ZBauer Jeff C · North Falmouth, MABuilt 1980 · S/N 28-7916380N214AALewis University · Romeoville, ILS/N 28-4735N214BPHolmes Aviation Inc · Webster, FLBuilt 2000 · S/N 3257156N214CALester Don · Campton, NHBuilt 1974 · S/N 28R-7435281N214GSStephens Mark · Cullman, ALBuilt 1972 · S/N 28-7205138N214JMVisions In Design LLC · Fairmont, WVBuilt 1977 · S/N 28R-7703059N214JPTop Flight Leasing LLC · Frankfort, ILBuilt 1994 · S/N 3213083N214JRMullet & Grits II LLC · Muskogee, OKBuilt 2005 · S/N 3232048N214RLlano Charles · Lakeland, FLBuilt 1977 · S/N 32R7780522N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440N214SANeagle Jason S · Elizabethtown, KYS/N 28-7415482N2150BGreen Head Flight Services LLC · Bemidji, MNBuilt 1979 · S/N 32R-7987031N2150FShoreline Aviation Inc · Marshfield, MABuilt 1978 · S/N 28-7916186N2150JKing Mark A · Nolensville, TNBuilt 1978 · S/N 28-7911064N2150RChalkley Benjamin G · North Liberty, IABuilt 1969 · S/N 28-5471N2150TBecker Brian C · Fort Dodge, IABuilt 1971 · S/N 28-7105165N2150YGoldstein Orpaz · Woodland Hills, CABuilt 1979 · S/N 28-7916360N2150ZHilton Head Flyers LLC · Liberty, SCBuilt 1979 · S/N 28-7916382N21522Hove Paul · St Paul, MNBuilt 1978 · S/N 28-7916046N2152AWojtowicz Jacek A · Rhinebeck, NYBuilt 1978 · S/N 28-7916099N2152ZN2152z LLC · Middletown, DEBuilt 1979 · S/N 28-7916383N2153MBlocklin Bruce · Port Charlotte, FLBuilt 1977 · S/N 28R-7803110
Back to AD 87-08-08 R3