OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N3419ZVintage Piper LLC · Lexington, KYS/N 22-7332N341AKGoddard Gary · Ohkay Owingeh, NMS/N 227411N341BEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 27-0341N341CBreaking Wind Aviation LLC · Brainerd, MNBuilt 2000 · S/N 2118N341CACovenant Air LLC · Wilmington, DEBuilt 1979 · S/N 31-7952243N341CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 27-8154006N341DCKiener Matthew J · Pottersville, NJBuilt 1996 · S/N 3246044N341DREcho Sierra Inc · Potomac Falls, VABuilt 1999 · S/N 18280467N341ECPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010041N341FAJb Aircraft LLC · Anchorage, AKS/N 17269321N341FCCondor Aero Club Inc · Zelienople, PABuilt 1978 · S/N 17270371N341FTWatkins Robert W II · Parsons, TNBuilt 1982 · S/N 28-8216210N341JCCopeland David Craig · Jackson, GABuilt 1978 · S/N R18200577N341LHBravo Gildaro F · Mcallen, TXBuilt 1997 · S/N 95-0341N341MKAlba Aviation Services Inc · Scottsdale, AZBuilt 2003 · S/N 3470N341NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881794N341PBPpb Aviation Management · Wading River, NYBuilt 1971 · S/N 17701661N341PCWoods Ronnie Lee · Weatherford, TXBuilt 1997 · S/N 18280014N341RAYang Chi · Lafayette, COBuilt 1978 · S/N 13118N341RVNelson Flyers Inc · Louise, TXBuilt 2005 · S/N 70586N341SLMartin David V · California, KYBuilt 1993 · S/N 2299N341SPSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9497N341STZimmie Thomas F · Wynantskill, NYBuilt 1973 · S/N 28-7305476N341SW13:4 Aviation LLC · Brookfield, WIBuilt 1969 · S/N 32-40592N341TAUnited States Of America · Travis Afb, CABuilt 2006 · S/N 2843634N341TBWil Aviate LLC · Merced, CAS/N 1696N341VHYachtphoto Helicopter LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2303MN34202Srs Aurora LLC · Saint Germain, WIBuilt 1972 · S/N 17701700N34206Jason Air Inc · Arlington, TNBuilt 1972 · S/N 17701704N34209Friesen Chevrolet Inc · Sutton, NEBuilt 1972 · S/N 17701707N3420MMoview Aviation LLC · Mountain View, MOBuilt 1977 · S/N 32R-7885007N3420NKurth Larry A · Williston, FLBuilt 1967 · S/N 680047N3420PKeyuravong Pisonth · Anchorage, AKBuilt 1958 · S/N 23-1384N3420QBalladares Charles V · Mandeville, LABuilt 1977 · S/N 28R-7737054N3420WBuffington Brian C · Gillsville, GAS/N 32-280N3420XBurns Kevin D · Decatur, TXBuilt 1966 · S/N 3397N3421EWisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 17271539N3421PLeever William L Trustee · Medford, ORBuilt 1958 · S/N 18-6775N3421XAltitude Aviation Servieces LLC · Mountain Home, IDS/N 3398N3421YMarshall Air LLC · Paso Robles, CABuilt 1979 · S/N R18201420N34223Strother Brenda J · Kenai, AKBuilt 1972 · S/N 17701715N34225Dexter Paul J · Orange, MABuilt 1972 · S/N 17701717N34227Neiser David R · Napavine, WABuilt 1972 · S/N 17701719N34228Thomas Andrew J · Brownsburg, INBuilt 1972 · S/N 17701720N34229Winchester Creek Aviation LLC · Waynesville, NCBuilt 1972 · S/N 17701721N3422TMangon Ronald A · Petaluma, CABuilt 1967 · S/N 17700722N34231Anderson Roger Q · Manassas, VABuilt 1972 · S/N 17701723N34232Nowacki James R · Brighton, MIBuilt 1972 · S/N 17701724N34233Stimpson Shawn S · Blackfoot, IDS/N 17701725N34235Nefc Inc · North Andover, MABuilt 1972 · S/N 17701726
Back to AD 87-10-06 R1