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.

N9598JMardis Andrew · Pelzer, SCBuilt 1966 · S/N 28-3744N9598MBergland John Edward · Santa Monica, CABuilt 1966 · S/N 670175N9598UJackler Leon J · Silver Spring, MDBuilt 1976 · S/N AA5A-0098N9598ZDel Valle Enterprises Inc · Sandpoint, IDBuilt 1989 · S/N 1102N9599CDomenico Joseph A · Saint Germain, WIBuilt 1978 · S/N 32-7840104N9599JOrban Kenneth D · Tellico Plains, TNBuilt 1966 · S/N 28-3745N9599KRed Wing Soaring Association · Osceola, WIBuilt 1989 · S/N 1111N9599WNelson Scott G · Lakota, NDS/N 28-23050N9599ZBorn John G · Jupiter, FLBuilt 1989 · S/N 1117N959AANorth Wheeler O · Carlsbad, CABuilt 2001 · S/N 23841N959AGGrant Altin C · Tahlequah, OKBuilt 1973 · S/N 17701952N959BWRegistered aircraftBuilt 1981 · S/N R18201706N959CVaero Inc · Vinton, VABuilt 1981 · S/N 27-8154029N959DBSigma Pharmaceuticals LLC · Monticello, IABuilt 1999 · S/N 14095CN959ERs Specialties LLC · Anchorage, AKBuilt 1955 · S/N 18-4021N959EDDoering Eric A · Litchfield, MNBuilt 2009 · S/N SS-001N959GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881473N959HCNorthwest Wings LLC · Hillsboro, ORBuilt 1973 · S/N 17262361N959MMBugle Equipment And Leasing LLC · Houston, TXBuilt 2003 · S/N 3257325N959PDMilligan Thomas A · Dana, INBuilt 2002 · S/N 1336-2002N959RDDoering Ray A · Devils Tower, WYBuilt 1979 · S/N 18-7909159N959RMLargent Richard B · Southport, NCBuilt 1970 · S/N 17259113N959RVRegistered aircraftBuilt 2013 · S/N 40637N959TELawless John M Jr · Tucson, AZBuilt 2004 · S/N 10238N959TTVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N T18208087N95AACoolidge Marvin L · Newberg, ORBuilt 1959 · S/N TD-256N95AGSale Reported · Montgomery, ALSale reportedBuilt 1990 · S/N 4622110N95AHBrown Hunter · Sulphur Rock, ARBuilt 1978 · S/N 18-7809152N95APWingnut Enterprises Inc · Sarasota, FLBuilt 1995 · S/N 32-46012N95AWScotts Air LLC · Prescott, AZBuilt 1996 · S/N 21087N95BEAmundson David Owen · Sioux Falls, SDBuilt 1964 · S/N TD-590N95BNMcphillips Flying Service Inc · Charlevoix, MIBuilt 1969 · S/N 95N95BRChickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 28-25841N95CHJones Cecil W · Fort Walton Beach, FLBuilt 2020 · S/N 80956N95CJSimmons Marshall · San Antonio, TXBuilt 1960 · S/N TD-334N95CPGates Thomas S · Moyock, NCBuilt 1976 · S/N 17265896N95DHHooker Douglas L · Spring Branch, TXBuilt 2017 · S/N JA1607096N95DJSanders Aviation Inc · Jasper, ALBuilt 1963 · S/N TD-556N95DLOwen Jayson S · Tampa, FLBuilt 1960 · S/N TD-418N95DRRoss Dan G · Newcastle, CABuilt 2010 · S/N 82434N95EDHaven Steven D Jr · Capac, MIBuilt 1996 · S/N 1N95EGNelson Gregory E · Austin, TXS/N 636-320-381FBN95EPFlying Cow LLC · Falls City, NEBuilt 1975 · S/N 32R-7680075N95FDLowrey Jonathan S · Jasper, INBuilt 1990 · S/N 785N95FHFlying Hawkes LLC · Hamilton, MTBuilt 2019 · S/N 082N95FSN95fs Ltd · Chicago, ILBuilt 1969 · S/N 30-1786N95GWSkypirate Aviation LLC · Staunton, VABuilt 1995 · S/N 21373N95HCCrosswell Joe · Springtown, TXBuilt 2016 · S/N 1210N95HDGreffenius Brian J · Covington, LABuilt 1995 · S/N 1255N95HFEddings Samuel David · Camino, CABuilt 1973 · S/N 28R7335311
Back to AD 87-10-06 R1