OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,428

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.

N1450RSammy Shwan · Danvers, MABuilt 1972 · S/N 28R-7335060N1450TBruce James E · Prattville, ALBuilt 1972 · S/N 28-7205300N1450XHopkins David M · Bell Buckle, TNBuilt 1975 · S/N 32-7500042N1452TAbacus Automation · Bennington, VTS/N 32-7240122N1454XPetrak Richard A · Hunker, PABuilt 1975 · S/N 28-7505230N1455XAviation Capital Management LLC · San Jose, CABuilt 1975 · S/N 28R-7535285N1456XYoung Daniel J · Cedarburg, WIBuilt 1975 · S/N 28R-7535286N145AAMuharsky Walter A Jr · Wilmington, NCS/N 28R-8131170N145ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010047N145LYQuarter To Two Flying Club Inc · Williamsport, PABuilt 2000 · S/N 28-43335N1460XSimpson Arthur Lee · Richland Center, WIBuilt 1975 · S/N 28-7525293N1461HJohnson Kent W · Clemons, IAS/N 28-7790313N1461TNiepert William · Jacksonville, NCBuilt 1972 · S/N 28-7225522N1462TWilliams Lesley J · Marquette, MIBuilt 1972 · S/N 28-7225523N1462XVerbsky Douglas Collins · Frisco, TXBuilt 1975 · S/N 28-7525300N1463HPrickett John M · Manchaca, TXS/N 28R-7703026N1463TN1463t LLC · Oak Hill, VABuilt 1972 · S/N 28-7225529N1464TSiedentopf Zyurelaie Indiana · Yelm, WABuilt 1972 · S/N 28-7205302N1464XSymmetry Inc · Sarasota, FLBuilt 1975 · S/N 28-7515410N1465HHolland Ray A · Blue Earth, MNS/N 28-7710002N1465TCaudle Tommie A · Bentonville, ARBuilt 1972 · S/N 32-7200040N1467TThree2tango LLC · Mount Pleasant, SCBuilt 1972 · S/N 28-7205305N1468THindle John Charles IV · Whitehouse Station, NJBuilt 1972 · S/N 28R-7235296N1469TThree Wing Flight School LLC · Stratford, CTBuilt 1972 · S/N 28R-7235297N146DB4405 LLC · Jenks, OKBuilt 1999 · S/N 3257100N146JWDodge Inc · Wilmington, DEBuilt 1976 · S/N 28-7615348N146LWBelvedere Inc · Marion, IABuilt 1979 · S/N 287911236N146MBMlc Flying Club LLC · Saint Peters, MOBuilt 1978 · S/N 32-7840160N146PTCoco Aircraft Inc · Merritt Island, FLBuilt 1979 · S/N 28-7916307N146SCFantasy Aire Inc · Wilmington, DEBuilt 1968 · S/N 32-985N146SWFairway Systems LLC · New Port Richey, FLBuilt 1980 · S/N 32-8006040N146XBrown Scott D · Bushnell, FLBuilt 2003 · S/N 3232010N1470HCherokee Air Inc · Lexington, SCS/N 32R-7780162N1471TFranks James Charles · Conroe, TXBuilt 1972 · S/N 28-7225528N1471XSale Reported · Epworth, GASale reportedBuilt 1975 · S/N 28-7525311N1472TGreen Lakes Aviation LLC · Belton, SCBuilt 1972 · S/N 28R-7235298N1474TStella Stephen G DBA · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240125N1474XKjeldsen Frederik C M · Poughkeepsie, NYBuilt 1975 · S/N 28-7515407N1476TBough Jayce K · El Dorado Hills, CAS/N 28-7225530N1476XAbel Adam T · Aberdeen, OHS/N 28-7525309N1477TSrh Club Inc · Wilmington, DEBuilt 1972 · S/N 28-7205306N1477XRed Rock Flying School LLC · Mesa, AZBuilt 1975 · S/N 28-7525313N1478XMello Edward R Jr · Land O Lakes, FLBuilt 1975 · S/N 28-7525292N1479TWnc Aviation LLC · Arden, NCBuilt 1972 · S/N 28R-7235302N1479XDunn Michael J · Nashua, NHBuilt 1975 · S/N 28-7515411N147CCBright Skies Inc · San Jose, CABuilt 1980 · S/N 28R-8131025N147GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881111N147LHSchool Board Of Brevard County Florida · Melbourne, FLBuilt 2003 · S/N 2844103N147PJVargas Luis A · Isabela, PRBuilt 1972 · S/N 32-7240134N1481XBadgerland Aero Club Inc · Fitchburg, WIBuilt 1975 · S/N 28R-7535289
Back to AD 87-08-08 R3