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.

N41669Hogan Daniel L · Chapel Hill, NCBuilt 1974 · S/N 28-7415312N4166CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N R18200334N4166FStalworth Leasing Inc · Burr Ridge, ILBuilt 1999 · S/N 2843263N4166HBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843119N4166MWoolace James L · North Pole, AKBuilt 1947 · S/N 12-3065N4166RRogers John K · Statesboro, GABuilt 2026 · S/N 92273N41674Swift Museum Foundation Inc · Athens, TNBuilt 1942 · S/N 101N41676American Roadways LLC · Missoula, MTBuilt 2000 · S/N 4636268N41677Northern Aviation LLC · Palmer, AKBuilt 1973 · S/N 585-73N41678Dodge Donald V · Newnan, GAS/N 586-73N4167AWilliams Mirage LLC · Denver, COBuilt 2000 · S/N 46-36254N4167CSsp Aviation LLC · Aurora, OHBuilt 1999 · S/N 4636201N4167DCraft Air Ventures LLC · Lake Jackson, TXBuilt 2000 · S/N 3257138N4167LPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2843318N4167NS&T Aviation LLC · Missoula, MTS/N 3257170N4167RZorychta Mary Ann · Clinton, ARBuilt 1968 · S/N 32-40483N4167SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 3257153N4167ZGolden Arrow Aviation Inc · Wilmington, DEBuilt 1965 · S/N 18-8349N41681Ralston Michael J · Calhoun, GABuilt 1973 · S/N 397-73N41684Nenahlo Thomas L · Anchorage, AKS/N 588-73N41686Atx Aero LLC · Austin, TXBuilt 1973 · S/N 398-73N4168HCordell Brad · Port Charlotte, FLBuilt 1995 · S/N 1263N4168JTwigg Donald A · Cumberland, MDBuilt 1966 · S/N 28-22503N4168RJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 32-40484N4168SDrew Dennis M · Danville, CABuilt 2000 · S/N 3257159N4168ZRc Aviation LLC · Grimes, IABuilt 2000 · S/N 3246169N41691Whiteknucle Aerobatics Inc · Blacksburg, VABuilt 1973 · S/N 591-73N41694Damiano Charles J · Orcutt, CABuilt 1973 · S/N 400-73N41695Guilfoyle Robert J · Shepherd, MTBuilt 1973 · S/N 593-73N41696Aaa Aviation LLC · Donalsonville, GABuilt 1973 · S/N 116-73N4169FRoelker Randall S · San Antonio, TXBuilt 1976 · S/N 28-7715007N4169RWollen Mark A · Poway, CABuilt 1968 · S/N 32-40566N4169TMiller Kenneth · Henderson, NVBuilt 2003 · S/N 3257313N4169XNusom William J · Hollis Center, MEBuilt 1969 · S/N 347N416APKizer Bret · Albany, ORS/N 47009TN416CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881121N416FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC016N416GSB & K Travel LLC · Wilmington, DEBuilt 1975 · S/N 27-7554094N416HHRotorwing LLC · Sheffield, ILBuilt 1997 · S/N 0415N416HPKt7 Aviation LLC · Katy, TXBuilt 1963 · S/N 28-1437N416JLCondren Ryan · Sunnyvale, TXBuilt 1967 · S/N 28-23944N416LDLake Cumberland Helicopter Tours LLC · Monticello, KYBuilt 2006 · S/N 11252N416PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843438N416RBWhite Jared William · Grass Valley, CABuilt 1972 · S/N 95N416RHMckamey Robert S · Tullahoma, TNBuilt 1994 · S/N 662N416RKWindyfork LLC · Black Mountain, NCBuilt 1966 · S/N 18-8434N416RPMiller Aircraft Services Inc · Crookston, MNBuilt 1974 · S/N 28-7415310N416RVRegistered aircraftBuilt 2003 · S/N 3167N416SDTailwheel Adventures LLC · Celebration, FLBuilt 1968 · S/N 191N416SSChristie Ian A H · Limon, COBuilt 1974 · S/N 721-74
Back to AD 87-10-06 R1