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.

N774GHarmon Larry · Springfield, OHS/N 001N774GAAircraft Resource Center Inc · Lakeville, MNBuilt 1978 · S/N GA7-0061N774HAExtreme Helicopter Service LLC · Alice, TXBuilt 1989 · S/N 1084N774JBJb Air LLC · Oakwood, GABuilt 2004 · S/N 1365-2004N774LLLedet Corp · Houma, LABuilt 2003 · S/N 3246213N774LRCampbell Jeffrey R · Surprise, AZBuilt 1974 · S/N 28R-7435297N774LSDroge John W · Sisters, ORBuilt 1977 · S/N 32-7840004N774MGPs Aviation Inc · Jackson, MNS/N 17269250N774NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881042N774PCHarrell Brian · Auburn, ALBuilt 1973 · S/N 28-7405018N774PDTump Christopher · Hartland, WIBuilt 1968 · S/N 17701281N774PKHcb Media LLC · Los Angeles, CABuilt 2011 · S/N 007N774PMAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 1-0055N774RPDanny Buys LLC · San Antonio, TXBuilt 2000 · S/N 25205N774RVSlutz Gary J DBA · Beach City, OHS/N 2047N7750DCarruthers Matthew L · Charlotte Hall, MDBuilt 1957 · S/N 22-5430N7750GVitt Edward J · Sewell, NJBuilt 1970 · S/N 17259450N7750MDoran Jeffrey · Westerville, OHBuilt 1974 · S/N 22-0016N7750PLeonardi Aldo · Woodland, CAS/N 24-2775N7750YWelden Charles R · Hoover, ALFirst renewal noticeBuilt 1965 · S/N 30-853N7751MM&M Aircraft LLC · Arnold, MOS/N 20-0013N7751PGulf South Aero LLC · Raymond, MSBuilt 1961 · S/N 24-2965N7751WSmith Derek D · Portland, ORS/N 28-1719N7752MSteen Robert Z · Billings, MTBuilt 1974 · S/N 21-0028N7752NCote Daniel A · Montpelier, VTS/N 28-5197N7752WCavender John S · Centerville, MDBuilt 1964 · S/N 28-1728N7753GCw Enterprise LLC · Jewell Ridge, VABuilt 1970 · S/N 17259453N7753MHangarone Air Services LLC · Los Altos, CAFirst renewal noticeBuilt 1974 · S/N 22-0017N7753NSonner Michael J · Golden, COBuilt 1968 · S/N 28-5198N7753PDarr Jacob L · Trinity, NCBuilt 1962 · S/N 24-2967N7753WNortheastern Oregon Flying Club Inc · La Grande, ORBuilt 1964 · S/N 28-1758N7753ZSt Louis Soaring Association Inc · Saint Louis, MOS/N 25-3936N7754GRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1970 · S/N 17259454N7754NSan Juan Flyers Inc · Pagosa Springs, COBuilt 1968 · S/N 28-5201N7754PMagner Air LLC · Leesburg, VABuilt 1961 · S/N 242969N7754VVos Jonathan R · Monee, ILBuilt 2018 · S/N 002N7754WMartin Travis James · Gladewater, TXBuilt 1964 · S/N 28-1772N7755DWellborn Ralph Lee · Kenai, AKBuilt 1957 · S/N 22-5436N7755GSagori Aviation LLC · Orlando, FLBuilt 1970 · S/N 17259455N7755PBubak Land And Cattle LLC · Imperial, NEBuilt 1961 · S/N 24-2971N77567Heiman Family Management LLC · Irvine, CABuilt 2004 · S/N 71210N7756BPeters Bruce G · Bakersfield, CABuilt 2015 · S/N 91009N7756DFalley Leighan T · Talkeetna, AKBuilt 1957 · S/N 22-5438N7756NSiegler Dylan Benjamin · San Mateo, CABuilt 1968 · S/N 28-5200N7756P56pop LLC · Fremont, OHBuilt 1962 · S/N 24-2972N7756ZBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1966 · S/N 25-3942N7757NArmbruster Paul A · North Ridgeville, OHBuilt 1968 · S/N 28-5203N7757ZMinden Soaring Club Inc · Minden, NVS/N 25-3943N7758GGallo Enterprises Inc · Wonder Lake, ILBuilt 1970 · S/N 17259458N7758PSkalsky Todd A · Hartley, TXBuilt 1961 · S/N 24-2974
Back to AD 87-10-06 R1