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.

N8414VWeller Steven C · Hummelstown, PABuilt 1971 · S/N 1614N8414WOhmacht Carlton J · Glenwood, MNBuilt 1965 · S/N 28-2638N8414YLone Oak Aviation LLC · Greenville, NCBuilt 1981 · S/N 28-8190279N8414ZCunningham Stanley A · New Braunfels, TXBuilt 1981 · S/N 28-8111082N84151Sanders George W · Cloverdale, INBuilt 1969 · S/N 17258358N84153Spirit Air Inc · Salmon, IDBuilt 1969 · S/N 17258360N8415FGrediagin Wayne · Anchorage, AKBuilt 1981 · S/N 32R-8113088N8415HAeronautica Aviation Inc · Port Orange, FLBuilt 1981 · S/N 32R-8113092N8415PFathoms LLC · Leland, MIS/N 71N8415RMahanna John A · Radcliff, KYBuilt 1966 · S/N 28-22348N8415YSchwend Brian · Forsyth, MTBuilt 1969 · S/N 18-8859N84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258362N84169Roach Gene T · Frankfort, KYS/N 17258363N8416JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1983 · S/N 0359N8416K8090 Alpha LLC · Grayslake, ILBuilt 1981 · S/N 32R-8113093N8416RExpert Staffing West Inc · Ramona, CABuilt 1966 · S/N 28-22293N8416WCass Aviation LLC · North Las Vegas, NVBuilt 1965 · S/N 28-2642N8416YHenze Charles R · Waukee, IABuilt 1967 · S/N 30-1567N84170Follmer Todd F · Dunwoody, GABuilt 1969 · S/N 17258364N84176Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8116275N8417CDolan Joseph B · Baltimore, MDBuilt 1976 · S/N 28-7625114N8417JAtkinson Joseph M · Phoenix, AZBuilt 1980 · S/N VAC-159-80N8417P250 Dash 4 Associates Ltd · Yellow Springs, OHBuilt 1964 · S/N 24-3669N8417YHighhouse Alan J · Honesdale, PABuilt 1970 · S/N 18-8861N84183Chickadee Aviation LLC · Burr Ridge, ILBuilt 1969 · S/N 17258368N84185Harrison Gene R · Pendleton, ORS/N 17258348N84186Gould George Jr · Bryantville, MABuilt 1969 · S/N 17258369N8418CWingman Aircraft Repair Inc · Lawrenceville, GABuilt 1976 · S/N 28-7615106N8418ETri-State Waterstoppers LLC · Ruffs Dale, PABuilt 1981 · S/N 28-8111083N8418JBrown Jerry D · Rio Rancho, NMS/N VAC-164-80N8418RCarlsson Carl J · Mason City, IABuilt 1966 · S/N 28-22295N8418WMadison Mike · Pittsburg, TXBuilt 1965 · S/N 28-2644N8418YHefner Joseph C · Mount Pleasant, TXS/N 30-1570N84190Frs & Craig Llp · Byron, GABuilt 1969 · S/N 17258371N84193Smirnov Alexei · Fair Lawn, NJBuilt 1969 · S/N 17258372N84194Ultra Aviation LLC · Cedar Bluff, VABuilt 1969 · S/N 17258373N84195Norcal Flight Center LLC · Lincoln, CABuilt 1969 · S/N 17258374N8419CMarsh Geoffrey E · Old Lyme, CTBuilt 1976 · S/N 28-7615107N8419HHoke William Jr · Charlestown, INBuilt 1981 · S/N 28-8190291N8419JHammonds Hangars Inc · Wilmington, DEBuilt 1980 · S/N VAC-168-80N8419RLytle Cole · North Palm Beach, FLS/N 28-22296N8419YMorrone Richard W · Westerly, RIS/N 30-1572N841ADCedar Real Estate Inc · Anaheim, CABuilt 1973 · S/N 32-7340079N841AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2003 · S/N 1317N841ATLuxury Transportation LLC · Talladega, ALBuilt 2004 · S/N 3257352N841BKKilpatrick Joseph C · Atlanta, GABuilt 1966 · S/N 28-3255N841CMTalley-Sickles Jacqueline M · Oxnard, CAFirst renewal noticeBuilt 1969 · S/N 28-5488N841EDR&D Aviation LLC · Fayetteville, GABuilt 1967 · S/N 28-4273N841GRegistration Pending · Painter, VARegistration pendingBuilt 2003 · S/N AG92777N841JARicci Theodore J · Spotswood, NJBuilt 1968 · S/N 17256902
Back to AD 87-10-06 R1