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.

N5818YWells John R · Gonzales, TXBuilt 1965 · S/N 27-2965N5819DMiceli Michael J · Frewsburg, NYBuilt 1956 · S/N 22-4494N5819LLandauer Jacob · Gainesville, FLBuilt 1972 · S/N AA5-0219N5819UOn Final Aviation LLC · Brookland, ARBuilt 1970 · S/N 28-26649N5819WKee Anthony S · Greenup, KYBuilt 1964 · S/N 28-1997N581BLGrundy Dennis E · Danville, INBuilt 2016 · S/N 20133N581COn Call Aviation LLC · Brentwood, TNBuilt 2003 · S/N 1271N581DMTichy Thomas H · Albuquerque, NMBuilt 2002 · S/N 894-2002N581ESQuinby Alan D · Woodward, OKBuilt 1978 · S/N 17271811N581FAbj Holdings LLC · Buckeye, AZBuilt 1998 · S/N 1407N581JDAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1995 · S/N 21912N581KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843916N581MTMiddle Tennessee State University · Murfressboro, TNBuilt 2004 · S/N 40.397N581NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496258N581SBHudson Harold Daniel · Williamsburg, VABuilt 1965 · S/N 3115N581SGOetting William C · Midland, ORS/N 3257049N58206Kiwi Choppers LLC · Hillsboro, ORBuilt 1978 · S/N 190768N58208Smith Helicopter Inc · Cotulla, TXBuilt 1979 · S/N 390780N5820QSmith Douglas C · Lewisville, TXBuilt 1965 · S/N 3119N5820UScarpelli Leonard · Lakewood, ILBuilt 1970 · S/N 28-26650N5820WRed Baron Aviation LLC · Pine Bush, NYBuilt 1964 · S/N 28-2000N5820ZWilson Jonathon D · Breckenridge, MIBuilt 1963 · S/N 22-9677N5821WEnander Johannes T · Grenora, NDS/N 28-2033N5822DFranz Stanley E · Yakima, WABuilt 1956 · S/N 22-4497N5822PJstream Lc · Sheridan, WYBuilt 1959 · S/N 24-903N5822QKnudsen Ernst W · Ennis, TXBuilt 1965 · S/N 3120N5822UCurliss James P · Quincy, MABuilt 1970 · S/N 28-26653N5823AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496260N5823QRegistered aircraftBuilt 1965 · S/N 777N5823UNewton Donald S · Elk Grove, CABuilt 1970 · S/N 28-26654N5823WHill Travis R · Aledo, TXBuilt 1964 · S/N 28-2070N5824DWitthuhn Johnie B · Callaway, NEBuilt 1956 · S/N 22-4499N5824PClaxton Fred E · La Habra, CABuilt 1959 · S/N 24-905N5824QTss-Glass Machinery Sales Inc · Fort Worth, TXS/N 3121N5824ULindaman Craig C · San Luis Obispo, CABuilt 1970 · S/N 28-26655N5824WBowman William K · Morrison, TNBuilt 1965 · S/N 28-2107N5824YDonahue Sean M · Fort Lauderdale, FLBuilt 1965 · S/N 27-2972N58250Gulick Stephen P · Burlington, VTBuilt 1985 · S/N 50N5825LMahurin Devin · Mountain Grove, MOBuilt 1972 · S/N AA5-0025N5825PRobles Carlos J · San Jose, CABuilt 1959 · S/N 24-906N5825QHobgood Joel A · Sharpsburg, GABuilt 1965 · S/N 778N5825TTeshima Mark William · Clovis, NMS/N 28-1595N5825UGantz Clayton B · Forestville, CABuilt 1970 · S/N 28-26656N5825WIndian Trucking Company Inc · Destin, FLBuilt 1965 · S/N 28-2113N5825YTalmage John R · Kalispell, MTS/N 27-2945N5826LGibson Bobby S · Clearwater, FLBuilt 1972 · S/N AA5-0026N5826QN5826q LLC · Sheridan, WYBuilt 1965 · S/N 3122N5826UHill Christopher L · Milner, GABuilt 1969 · S/N 28-26657N5827DNurge Richard · Gilroy, CAS/N 22-4502N5827PTwo Seven Papa LLC · Pueblo, COBuilt 1959 · S/N 24-908
Back to AD 87-10-06 R1