AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N82FMF J Corporation · Wilmington, DEBuilt 1999 · S/N 80834N82FWRemkes Wolfgang H J Trustee · Gilroy, CABuilt 2001 · S/N T18208027N82FYBurbage Richard W · Wichita Falls, TXBuilt 2009 · S/N 82302N82GCVolk James E · Argyle, TXBuilt 2004 · S/N 60545N82GHMorrison Richard L · Lake Como, FLBuilt 1982 · S/N 1N82HABeller Ronald D · Morehead, KYBuilt 1976 · S/N 17702401N82HYJohnson Michael T · Moatsville, WVBuilt 2002 · S/N 2191N82JStewart Michael W · Snellville, GAS/N JH111N82JNNicholas Kim A · Kent, WABuilt 2004 · S/N 90150N82KCDrake Raymond H · Asheville, NCBuilt 1998 · S/N 18280193N82KGBch Real Estate LLC · Eagle, IDBuilt 2005 · S/N T18208440N82KLMcdaniel Michael Ray · Hampton Cove, ALBuilt 1977 · S/N 24-0280N82KMShartle Austin W · Fredericksburg, PABuilt 1988 · S/N KM-02N82KPCarter Doug A · Tower, MNBuilt 2024 · S/N 318RN82LAAvery Lyle · Beach Lake, PABuilt 2000 · S/N 18280846N82LECollier County Sheriffs Office · Naples, FLBuilt 2004 · S/N 18281377N82LLSda Aviation LLC · Winnsboro, LABuilt 2000 · S/N 46-36289N82LRKristoferson John S · Denton, TXBuilt 1990 · S/N 82N82MReady Aim Flyer LLC · New Castle, DEBuilt 1958 · S/N TD-167N82MTMalo Blake Ridgway Trustee · Portland, ORBuilt 2017 · S/N 004N82NBMohillsmith Coulter · Temecula, CABuilt 2000 · S/N 001N82NDBaker David Jr · Louisville, KYS/N 0140N82PMCollings Foundation Inc · Hudson, MABuilt 1976 · S/N AA5B-0250N82RRegistered aircraftS/N 24564N82RBBurns Robert A · Fort Myers, FLS/N 3524N82RCShackelford John S Jr · Roanoke, TXS/N 0-540-2N82RDStrafford Cameron Cornell · San Diego, CAS/N 001N82RHHolte Brian J · Monticello, MNS/N 1-0003N82RJLynch James D Jr · Ocala, FLBuilt 1966 · S/N 30-1049N82RRCramp Steven J · Cleveland, TXS/N 001N82THBirrell Christopher James · Ottumwa, IABuilt 1999 · S/N 2042N82TTJaconetti William J · Saint Peters, MOS/N 616N82VWHeiman Caleb R · Summerfield, KSBuilt 2004 · S/N 23758N82WGHash Brian Morrison · Mattawa, WABuilt 1998 · S/N 18280388N82WHReed Joshua · Chesapeake, VABuilt 1981 · S/N 32R-8213026N82WKFarnum Kelly S · Midlothian, TXBuilt 2004 · S/N 60532N82WMBlackaby Kurt Allen · Bentonville, ARBuilt 1980 · S/N DB79N82ZACullen David F · Lantana, FLBuilt 1991 · S/N 10082N83003Bravo One LLC · Lewes, DEBuilt 1980 · S/N 44-8107018N83009Paris Air Inc · Vero Beach, FLS/N 28-8116088N8300JHepper Abby · Keene, NDBuilt 1980 · S/N 32R-8129010N8300RBodner Michael J · Rock Hill, SCBuilt 1966 · S/N 28-22168N83013Tjmc LLC · Riverbank, CABuilt 1980 · S/N 28-8116090N83016Maks97 LLC · Sparta, MIBuilt 1980 · S/N 28-8116091N8301CBeach Aero LLC · Virginia Beach, VABuilt 1975 · S/N 28R-7635144N8301FSorensen Daryl · Presque Isle, MIBuilt 1982 · S/N 32-8306004N8301PMann Herbert A · Soldotna, AKBuilt 1963 · S/N 18-8040N8301RGotgumbo LLC · Cranberry Township, PABuilt 1982 · S/N 32R-8329002N8301W01w Aero LLC · Conway, ARBuilt 1965 · S/N 28-2466N83021Kosbruk Boris R Jr · Perryville, AKBuilt 1980 · S/N 28-8190104
Back to AD 87-10-06 R1