OpenAirDocs.org
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.

N442MRSleigh Helicopter LLC · Palm City, FLBuilt 2020 · S/N 30063N442PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843498N442PDDesoto Parish Sheriff Office · Mansfield, LABuilt 2003 · S/N 10180N442PMBusby James D II · Port Saint Lucie, FLBuilt 2008 · S/N 40105N442PWBeluga LLC · Wasilla, AKBuilt 2002 · S/N 10002N442RDThompson Helicopters LLC · Uvalde, TXBuilt 2004 · S/N 10237N442RJHeymach Robert F · Holbrook, NYBuilt 2007 · S/N MK-0527N442RMRocky Mountain College · Billings, MTBuilt 2013 · S/N 4496347N442RNPope Jim D · Lewiston, IDBuilt 2006 · S/N 11047N442RTRm Capital Holdings LLC · Hockessin, DEBuilt 2026 · S/N 30110N442RYParagon Helicopter Services LLC · Claremore, OKBuilt 2003 · S/N 10096N442SGriffing Flying Service Inc · Port Clinton, OHBuilt 1976 · S/N 770N442SAG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 44-7995071N442SHRudd Wayne G · Basalt, COBuilt 2005 · S/N 10626N442TFerreira James M · Dixon, CABuilt 1998 · S/N 001N442TCCrawford Thomas A · Hawthorne, FLBuilt 2024 · S/N 92219N442TSLehman Aviation LLC · Winamac, INBuilt 2004 · S/N 10414N442TWMclaws Craig J · Sheridan, WYBuilt 1996 · S/N 001N442WBAllen Lanny D · Indianapolis, INFirst renewal noticeBuilt 1992 · S/N 1916N442WRWhite Ryan R · Polk City, IABuilt 2022 · S/N 90388N44308Hanson Garrett G · Snohomish, WABuilt 1974 · S/N 28-7410093N4430RDunder Neil DBA · Cicero, INBuilt 1974 · S/N 17263175N4430ULfm Aviation LLC · Bozeman, MTBuilt 1964 · S/N 15060430N4430YEvergreen Soaring Inc · Lynnwood, WABuilt 1966 · S/N 25-4056N44314Yates Cecil R · Westminster, CABuilt 1974 · S/N 28-7425403N44318Trinity Air Service Inc · Klamath Falls, ORS/N 28-7415621N4431AResetarits Matthew · West Seneca, NYBuilt 1956 · S/N 22-3760N4431QGraham Huber L · Gulf Breeze, FLBuilt 1973 · S/N 17261710N4431RRaritan Valley Flying School · Princeton, NJBuilt 1974 · S/N 17263176N4431TTaylor Timothy · Chandler, INBuilt 1971 · S/N 28-7125621N44326Mccaslin Dale Alan Trustee · Holt, MOBuilt 1974 · S/N 28-7405235N44327Big Duke Aviation LLC · Oshkosh, WIBuilt 1974 · S/N 28R-7435306N44328Riddle Bruce C · Franklin, NCBuilt 1974 · S/N 32-7440150N4432JKersch Robert · The Villages, FLBuilt 1967 · S/N 28-22835N4432RBend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17263177N4432ZTennant Carol J · Camp Crook, SDS/N 18-8771N44339Beac Inc · Old Hickory, TNBuilt 1974 · S/N 28-7415623N4433QTwo Dog Enterprises Inc · Madison, WIBuilt 1973 · S/N 17261712N4433ZBoll Nathan · Newburg, NDBuilt 1968 · S/N 18-8772N44347Registered aircraftBuilt 1974 · S/N 28-7415624N4434APutnam Michael D · Arnold, MOBuilt 1956 · S/N 22-3763N4434DAir Arctic Inc · Fairbanks, AKBuilt 1974 · S/N 31-7552020N4434JCarney Allen G · Weaubleau, MOBuilt 1967 · S/N 28-22838N4434QFaires Kelly C · Cedartown, GABuilt 1973 · S/N 17261713N4434RAll American Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 17263179N4434XLusher Frank W II · Prichard, WVBuilt 1975 · S/N 28R-7635041N4434ZWings Over Water Inc · Minneapolis, MNS/N 18-8774N44355Pray Aviation Inc · Augusta, KSBuilt 1974 · S/N 28-7415625N4435HEmtee Air LLC · Kalispell, MTBuilt 1978 · S/N 24-0731N44363Good Flight Aviation LLC · Stockton, CABuilt 1974 · S/N 28-7415626
Back to AD 87-10-06 R1