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.

N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219N2136MWashington Israel · Cincinnati, OHBuilt 1977 · S/N 28-7816253N2136PTrebbow Mike A · Santa Barbara, CAS/N 28R-7931064N2136YW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 28-7916368N2136ZPorta Frank T · Charleston, WVBuilt 1979 · S/N 28R-7918111N21372Halbert Ronald S · San Diego, CABuilt 1978 · S/N 32R-7887204N2137FColakoglu Migirdic · Hilton, NYBuilt 1978 · S/N 28-7911048N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205N2137NTa4 Ventures LLC · Greenwood Village, COS/N 28R-7931049N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160N2138FCima Christopher P · Plano, TXBuilt 1979 · S/N 32R-7987065N2138KGrigsby Aaron A · Victorville, CABuilt 1978 · S/N 32R-7987070N2138NJ T Air Inc · Dayton, MDBuilt 1979 · S/N 28-7911094N2139BN2139b LLC · Newark, DEBuilt 1978 · S/N 28-7911009N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145N2139ZAdkison Todd · Vinemont, ALBuilt 1979 · S/N 28R-7931160N213BPJim Nichols Air Service LLC · Fincastle, VABuilt 1986 · S/N 28-8690056N213CLevins Kenneth · Alameda, CABuilt 2006 · S/N 3257436N213SALatrobe Aviation Enterprises LLC · Youngstown, PABuilt 1973 · S/N 28R-7435138N2140TCupples Thomas Joseph · San Marcos, CABuilt 1971 · S/N 287105162N2140VSidhu Harish · Anaheim, CABuilt 1979 · S/N 28-7990340N2140YNorcal Flight Club · Vacaville, CABuilt 1979 · S/N 28-7916372N2140ZRosier Nicholas A · York Haven, PAS/N 28-7921016N21411Piper Partners · Coventry, CTBuilt 1978 · S/N 28-7990044N21412Long Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990045N21418Woodard Christopher Shane · Forney, TXBuilt 1978 · S/N 32-7840185N2141JRegistered aircraftBuilt 1978 · S/N 28-7990221N2141RM5:16 Ventures LLC · Brush Prairie, WABuilt 1979 · S/N 28-7990302N2141THorizon Ventures Inc · Red Oak, IABuilt 1971 · S/N 28R-7135144N21425Nelson Phillip · Jonesboro, ARS/N 32R-7887207N2142MWatson Kenneth · Atlanta, GABuilt 1979 · S/N 28R-7931040N2142RFieldhouse Warren W · Ocala, FLBuilt 1969 · S/N 28-5469N2142XAnvab Inc DBA · Concord, NHBuilt 1979 · S/N 28R-7918089N2142YChanfrau Frederic · Barrington, RIS/N 28-7911142N21435Car Guys Aviation LLC · Lead, SDBuilt 1978 · S/N 32R-7887210N21436Smith Michael W · Bracey, VABuilt 1978 · S/N 32R-7887211N2143BLance Aviation Corp · Houston, TXBuilt 1978 · S/N 32R-7987028N2143PMcgrath Susan · Morehead City, NCBuilt 1979 · S/N 28-7911103N2143TRahim Shamim Inc · Jacksonville, NCBuilt 1971 · S/N 28-7125454N2143YBk Aviation Services LLC · Graford, TXBuilt 1979 · S/N 28-7916357N2143ZJackson Kevin · Fishers, INS/N 28-7921019N21441Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916040N21442Ducote Randal J · Parker, COBuilt 1978 · S/N 28-7990048N21443Compton James R · Boise, IDBuilt 1978 · S/N 28-7990049N21449Curry Robert B · Delphos, OHBuilt 1978 · S/N 32-7840186N2144JCraft James Thomas Jr Trustee · Clinton, MSBuilt 1978 · S/N 28R-7931010N2144MFour Four Mike Inc · Yukon, OKBuilt 1979 · S/N 28R-7931041N2144NPaxton Matthew P · Ketchum, IDBuilt 1979 · S/N 28-7911096N2144THilds Marine Service Inc · Pasadena, MDBuilt 1971 · S/N 28-7105166
Back to AD 87-08-08 R3