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.

N9874VSisler Allen R · Terra Alta, WVBuilt 1974 · S/N 17264540N9874WMcanally Cameron F · Battle Ground, WABuilt 1967 · S/N 28-23394N9875DMunich Tristan S · Yakutat, AKBuilt 1959 · S/N 18-7009N9875G1 Aircraft LLC · Kissimmee, FLBuilt 1971 · S/N 17259775N9875MKaelin Robert A · Fayetteville, ARBuilt 1972 · S/N 17260575N9875NBulldog Pilots Association LLC · Waconia, MNBuilt 1976 · S/N BH-120-379N98763Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276344N98769American Patrols Inc · Midland, TXBuilt 1985 · S/N 17276345N9876GKentucky Lake Aviation LLC · Huntingdon, TNBuilt 1971 · S/N 17259776N9876JK & S Irrigation Inc · Higbee, MOBuilt 2003 · S/N 1284N9876QRegistered aircraftBuilt 1975 · S/N 17265820N9876SBlack Forest Soaring Society Inc · Monument, COS/N 25-4116N9876VDelhotal Raymond K · West Brooklyn, ILBuilt 1974 · S/N 17264541N9876WFoster John D · Grapevine, TXBuilt 1967 · S/N 28-23396N98772Solberg Aviation Co Inc · Whitehouse Station, NJBuilt 1985 · S/N 17276347N98774Simplifly LLC · Mesa, AZBuilt 1985 · S/N 17276349N98776Melbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276350N9877BAndra Joshua Corey · Riverton, UTBuilt 1982 · S/N 172RG1066N9877DAdams Bob L · Eagle River, AKBuilt 1959 · S/N 18-6899N9877GRowse Larry G · Plain City, OHBuilt 1971 · S/N 17259777N9877UNaval John A · Auburn, WABuilt 1976 · S/N AA5A0277N9878GRoyal Aviation Academy LLC · Sarasota, FLBuilt 1971 · S/N 17259778N9878PSeattle Glider Council Inc · Bellevue, WABuilt 1975 · S/N 25-7556217N9878QNesland Patricia M · Burton, WAS/N 17265822N9878URock N Roll Flying Club LLC · Omaha, NEBuilt 1976 · S/N AA5A0278N9878WBenton Michael L · Gilbert, SCBuilt 1967 · S/N 28-23398N9878YWaterman David N · Amery, WIS/N 7KC-3N98792Stanzione Daniel F · Antelope, CABuilt 1985 · S/N 17276355N98795Richmor Aviation Inc · Scotia, NYBuilt 1985 · S/N 17276357N9879DGlenwood Farm LLC · Edgerton, MOBuilt 1959 · S/N 18-6901N9879FClift Murray · Chewelah, WAS/N 18280057N9879PPetersen Conrad · Kenmare, NDBuilt 1975 · S/N 25-7556208N9879QCoker Design Group LLC · Campobello, SCS/N 17265823N987ANf County Flying Club Inc · Chateaugay, NYBuilt 2003 · S/N 921-2003N987ACKnight Tracy D · Reno, NVBuilt 2004 · S/N 987N987AVMoore Aviation Inc · Beaver Falls, PABuilt 1998 · S/N 17280585N987BBTime Building LLC · Lake Oswego, ORBuilt 1988 · S/N 1004N987BCWings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280471N987CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280241N987DSMission Boston D-Day LLC · Parker, COS/N 31-79N987EDupre Alan A · Shelbyville, KYBuilt 1990 · S/N 01N987EGPensacola Navy Flying Club Inc · Pensacola, FLBuilt 1972 · S/N 28R-7335027N987JBCassill Aircraft Leasing Inc · Cedar Rapids, IAS/N 987JBN987PGriffith Robert G · Sacramento, CABuilt 2001 · S/N 2133N987SLBell Steven C · Lamesa, TXBuilt 2006 · S/N 1028KCMN987TReady Aim Flyer LLC · New Castle, DES/N TD-405N987TDRegistered aircraftBuilt 1974 · S/N 28R-7535075N9880GHewlett John · Columbus, OHBuilt 1971 · S/N 17259780N9880QAircraft Resource Center Inc · Lakeville, MNBuilt 1975 · S/N 17265824N9880WJuhl Aaron · Overland Park, KSBuilt 1967 · S/N 28-23400
Back to AD 87-10-06 R1