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.

N31PAUtter Joseph Lynn · Springfield, MOBuilt 1967 · S/N MA-132N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349N31PEPhantom Eagle LLC · Hot Springs, VAFirst renewal noticeBuilt 1996 · S/N 14086CN31PLGorum Michael Wren · Red Lodge, MTBuilt 1998 · S/N 18280095N31PPPlyler Aviation Lp · Sherman, TXBuilt 1969 · S/N PP-1N31PRAlpha Whiskey 1 LLC · Brandon, MSBuilt 1979 · S/N 317952049N31PWClark David L · Washoe Valley, NVBuilt 1968 · S/N 32-40510N31RKf Lift LLC · Snyder, TXBuilt 1978 · S/N 32R-7885150N31RBTigre Ecossais Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N AA5B-0156N31RDIsland Bound LLC · Dunedin, FLS/N 31-7852059N31REManley Brian C · Glen Allen, VABuilt 1966 · S/N 32-530N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693N31SN31s LLC · Wadsworth, OHBuilt 1971 · S/N 28-7205080N31SCObryant Jeffrey A · Fairbanks, AKBuilt 1967 · S/N 79N31SETangent LLC · Phoenix, AZBuilt 2005 · S/N 978-2005N31SGHamilton Enterprises Inc · Reno, NVBuilt 1996 · S/N 377-320-132-18PN31SMWings Over Texas Aviation Inc · Killeen, TXBuilt 1965 · S/N 635N31TAFulltron Aviation LLC · Springfield, MOBuilt 2001 · S/N 6047N31TBRusso Christopher · Huntsville, TXS/N 483N31TDLewis Timothy H · Bristow, VABuilt 2010 · S/N 40059N31TEMiller David A · Albany, ORBuilt 1984 · S/N 31-8452012N31TGNaiman Nicholas A · Ramona, CABuilt 1995 · S/N TJ2-8-38GN31THNet Air Co · Monroe, MIBuilt 1979 · S/N AA5B1142N31TJAdams Ian B · Laramie, WYBuilt 2002 · S/N 60414N31TLT M L Aircraft Inc · Narrowsburg, NYS/N 28R-7235314N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054N31UPGuardian Aero LLC · Flora, ILBuilt 2013 · S/N 2294N31VCVelocity Cruisers LLC · Mabank, TXBuilt 2001 · S/N 3RX015N31VGTita Enterprises LLC · Apex, NCBuilt 2004 · S/N 3551N31VHAmy Inc · Wilmington, DEBuilt 2005 · S/N 3966N31VSJenny Timothy J · Remsen, NYBuilt 1999 · S/N 1273-99N31VTSnediker Daniel G · Pittsburgh, PABuilt 1966 · S/N 28-3208N31VXGordon Charles M Trustee · Haymarket, VABuilt 2018 · S/N 00182N31WBBaker James P · Brighton, COBuilt 1995 · S/N 22470N31WFTaylor Peter L · Beaumont, TXBuilt 1999 · S/N 1461N31WGFleischman James H · Remus, MIBuilt 1990 · S/N 1951N31WHDerbecker David G · Katy, TXBuilt 1969 · S/N 24-4810N31WKKing Wesley A · Los Angeles, CABuilt 1995 · S/N 1060N31WM3 Point Aviation LLC · Claremont, NHBuilt 2018 · S/N CC19-0027N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291N31XEverson Dustin J · Providence, RIBuilt 1992 · S/N 671-92N31YBritton Stephen D · Delhi, LABuilt 1957 · S/N TD-41N31ZRRusso R Michael · Pipersville, PABuilt 2004 · S/N 23093N32003Gem Aviation Corp · Sugar Land, TXBuilt 1974 · S/N 28-7515043N32004Priceless Pleasures LLC · Jordan, MNBuilt 1974 · S/N 28-7515044N32008K L M Aircraft Co · Media, PABuilt 1974 · S/N 28-7505014N3200ERegistration Pending · Burlington, WIRegistration pendingBuilt 1978 · S/N 17271466N3200GSpinner Family Limited Partnership · White City, ORBuilt 1956 · S/N 22-4042N3200MPride Jesse D · Eagle River, AKS/N 12-1872N3200RTexeira David A · Venice, FLBuilt 1969 · S/N 28R-31126
Back to AD 87-10-06 R1