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.

N79445Raniolo James · Jackson, WYBuilt 1969 · S/N 17258094N79447Aroostook Aviation LLC · Millinocket, MEBuilt 1969 · S/N 17258096N79448Thomas William B · Converse, LABuilt 1969 · S/N 17258097N7944CAugter Gary K · Mcalester, OKS/N 28-7690091N7944GBogardus Peter S · Gouverneur, NYBuilt 1970 · S/N 17259644N7944HForsgren Kyle C · Wasilla, AKBuilt 1946 · S/N 12-847N7944NInspire Aviation LLC · Magnolia, TXBuilt 1969 · S/N 28-5360N7944POber John A · Candor, NYBuilt 1962 · S/N 24-3180N7944WPadisak Michael · Traverse City, MIBuilt 1964 · S/N 28-1987N79450Smith Jeff C · Cincinnati, OHBuilt 1969 · S/N 17258099N79453Zimmer James E · Corning, CABuilt 1969 · S/N 17258101N79454Gavranovic Willie · Wharton, TXBuilt 1969 · S/N 17258102N7945GWinger Matthew · Vail, AZS/N 17259645N7945LBertsch David L · Caldwell, IDBuilt 1966 · S/N MB-144N7945NWittenbrader Jeffrey M · Lake Ariel, PABuilt 1969 · S/N 28-5361N7945PArey Paul R · Cambridge, MDBuilt 1962 · S/N 24-3181N7945WOnward Enterprises LLC · Laurel, MSBuilt 1964 · S/N 28-1989N7945YLevel Up Aviation LLC · Newton, ALBuilt 1966 · S/N 30-1039N79468Whitmire Alan K · Canyon Lake, TXS/N 17258113N7946GRegistration Pending · Beach City, TXRegistration pendingBuilt 1970 · S/N 17259646N7946NSommer Matthew D · Whiteford, MDBuilt 1969 · S/N 28-5362N7946PLarsen Jordan T · Draper, UTBuilt 1962 · S/N 24-3182N7946WCushman Jeffrey R · Superior, WIBuilt 1964 · S/N 28-1990N79472Frey Michael L III · Waco, TXBuilt 1969 · S/N 17258115N79475Registered aircraftBuilt 1969 · S/N 17258118N79477Shipley David L · Yates City, ILBuilt 1969 · S/N 17258120N79478Fusano Lisa A · La Crescenta, CAS/N 17258121N79479Larue Mark C · Leander, TXBuilt 1969 · S/N 17258122N7947GStearman Field Aircraft Repair LLC · Benton, KSBuilt 1970 · S/N 17259647N7947PThorpe Jack · Raleigh, NCBuilt 1962 · S/N 24-3183N79482Matacotta Ernest A · Marietta, GABuilt 1969 · S/N 17258123N79488Nevels Steven D · Merritt Island, FLBuilt 1969 · S/N 17258126N79489Maisonet Gonzalez Hector W · Ocala, FLBuilt 1969 · S/N 17258127N7948NHayes William B · Saint Charles, MOBuilt 1969 · S/N 28-5364N7948PDeruelle David · Shingle Springs, CABuilt 1962 · S/N 24-3184N7948WCruse Billy · North Bend, WAFirst renewal noticeS/N 28-1992N7949Thermoking Of Fargo & Isuzu Diesel Midwest · Fargo, NDBuilt 1970 · S/N 18-8882N79493Bounds Trucking LLC · Faison, NCS/N 17258130N79498Gord James F · Sandwich, ILBuilt 1969 · S/N 17258132N79499Johnson Benjamin M · Monroe, WIBuilt 1969 · S/N 17258133N7949NGuess-Slatosky Carrie · Randleman, NCBuilt 1969 · S/N 28-5365N7949PWalters Donald J · Mohave Valley, AZBuilt 1962 · S/N 24-3186N7949YReeve Howard E · Minot, NDBuilt 1966 · S/N 30-1045N794AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843797N794AKFlying Dutchman LLC · Wasilla, AKBuilt 2021 · S/N 001N794BKMaxlines LLC · Fairfax, CABuilt 1979 · S/N 28-7916556N794RSRegistered aircraftS/N 27-0007N794SATmb Aviation LLC · Fresno, CABuilt 2001 · S/N T18208062N79501Skyhawk Flying Club Inc · Omaha, NEBuilt 1969 · S/N 17258134N79506Allen Michelle E · Sebastopol, CABuilt 1969 · S/N 17258138
Back to AD 87-10-06 R1