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.

N74088Mcgee Neil R · Littleton, NCBuilt 1975 · S/N AA5B-0125N7408DTobin John C · Olympia, WAS/N 22-5169N7408JHiller Alex T · Lake Orion, MIBuilt 1968 · S/N 28-24773N7408PJeffrey Thomas James · Crestwood, KYBuilt 1961 · S/N 24-2595N7408RAdventures Aviation LLC · Whitehouse Station, NJBuilt 1966 · S/N 28-21925N7408VM Twenty Inc · Bismarck, NDBuilt 1975 · S/N 22-1201N74090Tiger Air LLC · Chatsworth, CABuilt 1975 · S/N AA5B-0126N74092Mcgill John G · Atlanta, GABuilt 1975 · S/N AA5B-0127N74094Eastern Shore Flying Service Inc · Wilmington, DEBuilt 1976 · S/N AA5B0395N74095Benson Edwin R · Gulfport, FLBuilt 1975 · S/N AA5B-0133N74096Borden Lester N · Dalzell, ILBuilt 1975 · S/N AA5B-0134N74099Sigg David · Bluffton, SCBuilt 1975 · S/N AA5B-0135N7409DBartlett Donald R · Weirsdale, FLBuilt 1957 · S/N 22-5170N7409GAero Quest LLC D/B/A · Olive Branch, MSBuilt 1970 · S/N 17259109N7409JAdp Consultants Inc · Laurel, MDBuilt 1968 · S/N 28-24774N7409PPeters Gordon J · Salem, ORBuilt 1961 · S/N 24-2596N7409ZFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeBuilt 1965 · S/N 25-3375N740AMHawbaker Michael S · Warrenton, MOBuilt 1985 · S/N 32R-8513016N740CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281764N740HCVuksanovic David A · Fountain Hills, AZBuilt 1984 · S/N 31P-8414043N740HNBailey Roland L · Frazeysburg, OHBuilt 1967 · S/N 28-10887N740HSSnook Harold F · Beaver Springs, PABuilt 1977 · S/N 18-7709067N740NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843857N740PASkywest Leasing Inc · St George, UTBuilt 2016 · S/N 2843834N740RHUnited Helicopter Leasing LLC · Honolulu, HIBuilt 2018 · S/N 2559N740UOhio University · Albany, OHBuilt 2005 · S/N 2842225N740WTCentral Valley Flight School LLC · Hanford, CABuilt 1969 · S/N 28R-31029N74100Derby Kent E · Denver, COBuilt 1975 · S/N AA5B-0136N74101Mickelsen Brian C · South Jordan, UTBuilt 1975 · S/N AA5B-0137N74104Supan J T Trustee · Santa Cruz, CABuilt 1975 · S/N AA5B-0139N74105Lamphier Marc S · Lawrence, MABuilt 1975 · S/N AA5B-0140N74109Piscitello Thomas J · Yulee, FLBuilt 1975 · S/N AA5B-0145N7410DHampton Michael D · Marshfield, MOFirst renewal noticeBuilt 1957 · S/N 22-5171N7410JGeorge Ladelle · Ashley, NDBuilt 1968 · S/N 28-24775N7410RElon Aviation LLC · Burlington, NCBuilt 1966 · S/N 28-21927N7410WKlassen Peter K · Seminole, TXBuilt 1965 · S/N 28-2897N7410YDuncan Paul J · Bartlett, TNBuilt 1964 · S/N 30-472N7411DMclain Joseph L · Louisville, KYBuilt 1957 · S/N 22-5172N7411SNaik Narayan · Claremore, OKBuilt 1969 · S/N 60-0016N7411VDk Aero LLC · Wilmington, DEBuilt 1975 · S/N 22-1204N74127Richards Michael W · Lafayette, INBuilt 1975 · S/N AA5B-0147N7412JDubois Aviation Inc · Chino, CABuilt 1968 · S/N 28-24778N7412PEspyess Aviation LLC · Sylvania, OHBuilt 1961 · S/N 24-2600N7412RZembinski Robert A · Brookfield, WIBuilt 1966 · S/N 28-21929N7412WRegistered aircraftRegistration pendingBuilt 1963 · S/N 28-1300N7413DDraper Scott · Rutland, VTBuilt 1957 · S/N 22-5174N7413JLittle Evin M · Bidwell, OHBuilt 1968 · S/N 28-24779N7413RRegistration Pending · Gilbert, AZRegistration pendingS/N 28-21930N7413WRivera Genaro · Clarksville, TNBuilt 1963 · S/N 28-1301N7413YOutka Air LLC · Aberdeen, SDBuilt 1964 · S/N 30-475
Back to AD 87-10-06 R1