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.

N622DXChang Daniel H · La Crescenta, CABuilt 1979 · S/N 24-0851N622EHaggerty Russell P · Bethpage, NYBuilt 1971 · S/N 17260059N622EXErdman Jeffery L Sr · Montague, MIBuilt 2021 · S/N JA1611101N622FLMontgomery Lauryn A · Minor Hill, TNBuilt 1971 · S/N 28-7125509N622FTReese William A · New Smyrna Beach, FLBuilt 1991 · S/N 10022N622GPTwenty Two Ashford LLC · Brentwood, TNBuilt 1981 · S/N 17274593N622JBSun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 44-7995080N622KCarr Randal J · Chandler, OKBuilt 1975 · S/N 27-7554088N622KCAir Burt LLC · Rochester Hills, MIBuilt 2001 · S/N 18281043N622KSSpears Jason M · Milton, WVBuilt 1994 · S/N 622ESN622LTim Myers · Naples, FLBuilt 2024 · S/N PX1520030N622LHSugarbush Soaring Association Inc · Warren, VTBuilt 2012 · S/N 18109CN622NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881160N622NL1st American Aviation Inc · North Miami, FLS/N 0386N622SAParker Helicopter LLC · Watsonville, CABuilt 2005 · S/N 3912N622TBPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854091N622TTLonczak Mark J · Folsom, CABuilt 1995 · S/N 1N6230DUsda Aphis Wildlife Services · Cedar City, UTBuilt 1979 · S/N 17272648N6230JSonnichsen Landen D · Delta Junction, AKBuilt 1976 · S/N 32R-7680337N6230URutter Bruce W · Ralph, MIBuilt 1962 · S/N 2069N6230YRegistration Pending · Chapmansboro, TNRegistration pendingBuilt 1966 · S/N 27-3459N6231EMiller Edward P · Northfield, MNBuilt 1978 · S/N 17272001N6231FH & F Aviation Inc · Labelle, FLS/N 17273170N6231HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816238N6231WMission Air LLC · Oklahoma City, OKBuilt 1964 · S/N 28-20271N6232DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272650N6232WN6232w LLC · Rushland, PABuilt 1964 · S/N 28-20272N62332Skylens LLC · Hammond, LABuilt 1981 · S/N 17275251N6233DGrauert Ritter Trustee · Van Nuys, CAS/N 17272651N62348Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275254N6234CSchilling Aviation Services LLC · Salina, KSBuilt 1978 · S/N 28-7890349N6234JLane Jerry P · Grinnell, IABuilt 1976 · S/N 28-7615339N6234LHenderson Cathy H · Gordon, TXBuilt 1993 · S/N 1949N6234UNabert Maher K · Augusta, GABuilt 1962 · S/N 2073N6234VAnderas Per R · Green Bay, WIBuilt 1993 · S/N 2156N6234WDahlenburg Tory L · Smyrna, TNBuilt 1964 · S/N 28-20275N6234XMoeller Raymond H II · Willowbrook, ILBuilt 2019 · S/N 001N62350Flycarolina LLC · Concord, NCBuilt 1981 · S/N 17275255N62354Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275256N6235HAirworthyone LLC · Caledonia, MIBuilt 1977 · S/N 28-7890219N6235JFrost Aviation Services Inc · Las Cruces, NMBuilt 1976 · S/N 28-7615341N6235YBeaver Douglas G · Harleysville, PAS/N 27-3467N6235ZRizzuti Robert T · Theodosia, MOBuilt 1987 · S/N 5128N62367Nehl Seth M · Mandan, NDS/N 18-4334N6236CAviation Equipment Company LLC · Leesburg, VABuilt 1978 · S/N 28R-7837151N6236JArcher N6236j LLC · Denver, COBuilt 1976 · S/N 28-7690377N6236PHill Scott G · Mcdonough, GABuilt 1959 · S/N 24-1341N6236WBjornstad John · Maple Grove, MNS/N 28-20278N6237JHulett Michael · Saginaw, MOBuilt 1976 · S/N 28-7690378N6237UCardoza Roger A · Fairbanks, AKBuilt 1962 · S/N 2076
Back to AD 87-10-06 R1