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.

N7889WBetts Paula H · Valparaiso, INBuilt 1964 · S/N 28-1913N788BGSeminole Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 4496143N788BWNelson Thomas H Jr · Chatham, MSBuilt 1997 · S/N 1230-97N788CADunekacke Joel F · Elk Creek, NEBuilt 1978 · S/N 32R-7887256N788JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020088N788JBIsert Brian L · Melba, IDBuilt 2018 · S/N 40335N788JGJg Aviation LLC · Westport, CTBuilt 2004 · S/N 3257369N788MCRoberts James A · Edina, MNBuilt 1978 · S/N 17270430N788RKSalomonsson Mats E · Hayward, CAS/N 28-24831N788RVHigh Flight Aviation Inc · Wilmington, DEBuilt 2008 · S/N 82297N788SStrauss Richard A · Palm City, FLBuilt 1981 · S/N 32R-8113097N788SHSouthwest Technology Center School Dist No. 27 · Altus, OKBuilt 2004 · S/N 3631N788TDBurdick Kelly E · Wasilla, AKBuilt 1972 · S/N 18-9001N788TKRudd Wayne G · Basalt, COBuilt 2005 · S/N 10703N788WTFletcher Joseph E · Enid, OKBuilt 1999 · S/N 25036CN788XDonahue Patrick J · Carriere, MSBuilt 1997 · S/N 793-97N788ZStaton Robbie L · Lonoke, ARS/N 670N78901Emslie Ronald H · Sacramento, CABuilt 1961 · S/N 1915N78903Brar Kulbir Singh · Fresno, CABuilt 1961 · S/N 1917N78907Pritchard John A · Perry, KSS/N 1921N78909Takemura Chris · Mountain View, CABuilt 1961 · S/N 1923N7890GAltus Aircraft LLC · Taylor, TXBuilt 1970 · S/N 17259590N7890VDoherty Kevin R · Silver Spring, MDBuilt 1964 · S/N 2852N7890YMhr Leasing LLC · Hickory Corners, MIBuilt 1966 · S/N 30-977N78911Watt Charles D · Marietta, OHBuilt 1961 · S/N 1940N78912Mid America Plumbing LLC · Moscow, TNBuilt 1961 · S/N 1941N78913Ambrose Gary L · Camden, NCBuilt 1961 · S/N 1942N78914Collins Camden B · Millersport, OHS/N 1943N78915Hendryx Alec B · Coffeyville, KSBuilt 1961 · S/N 1944N78918Pearlman Fredric M · Southfield, MIBuilt 1962 · S/N 1952N7891GSam Aviation LLC · Long Beach, CABuilt 1970 · S/N 17259591N7891PN7891p Partners LLC · Suffolk, VABuilt 1962 · S/N 24-3120N7891WN7891w LLC · North Las Vegas, NVBuilt 1964 · S/N 28-1916N78920Duncan Mark T · Orange Grove, TXBuilt 1961 · S/N 1954N78923Rodriguez Julian P · New York, NYBuilt 1961 · S/N 1957N78925Sale Reported · Winthrop, MESale reportedBuilt 1962 · S/N 2037N78927Sly David P · Nevada, IAS/N 1961N78928Lejcar Matthew J · Cumberland Furnace, TNBuilt 1961 · S/N 1962N78929Boccaccio Peter A · Burke, SDS/N 1963N7892VLambert Mathew Chase · Chapel Hill, TNBuilt 1964 · S/N 2854N7892WRegistered aircraftBuilt 1964 · S/N 28-1917N7892YHarrison Richard J · South Hamilton, MABuilt 1966 · S/N 30-979N78930Klingenberg Richard A · Idaho Falls, IDBuilt 1961 · S/N 1964N78934Harville Leonard W · Giddings, TXBuilt 1961 · S/N 1968N78936Napier James C · San Diego, CABuilt 1962 · S/N 1970N78937Reisen LLC · Stevensville, MTBuilt 1961 · S/N 1971N78938Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257794N7893DMoes John E · Manchester, IABuilt 1957 · S/N 22-5516N7893GRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1970 · S/N 17259593N7893PBas Part Sales LLC · Greeley, COS/N 24-3122
Back to AD 87-10-06 R1