OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N318ME1st Avenue Ttc LLC · Los Angeles, CABuilt 1977 · S/N 301/27-003N318MFBusy Bee Helicopters LLC · Lone Jack, MOS/N 0073N318PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496134N318PKValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 32R-7887037N318PWN318pw LLC · New Canaan, CTBuilt 1973 · S/N 17262171N318RALouden Bruce H · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 13048N318RCLafrance Lon H · Rocky Mount, MOBuilt 1977 · S/N 17269183N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184N318SPace Glen M · Columbia, MSS/N 76-32-164N318TCGilmer Thomas · Toccoa, GABuilt 1976 · S/N 60-0316-117N318TMOgino Todd T · Barrington, ILBuilt 2009 · S/N 71942N318VFShramek Troy A · Bossier City, LABuilt 1973 · S/N 17702008N318WMQuinn James Yancie · Farmers Branch, TXBuilt 2001 · S/N 1327N31900Woodward Joseph A Jr · Wshngtn Xing, PABuilt 1978 · S/N 28-7816592N31905Weishuhn Aviation LLC · Farwell, MIBuilt 1978 · S/N 28-7890484N3190BThomas Peter G Trustee · Reno, NVBuilt 1953 · S/N 25432N31916Registered aircraftS/N 32-7840155N3191MHerder John P · Phoenix, AZBuilt 1947 · S/N 12-2007N3191PStone Clifford F Jr · Corning, CABuilt 1957 · S/N 23-1129N31920Sarasin Stuart P · Au Train, MIS/N 32R-7887015N31923Metro Aicraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816597N31926Van Cura Don · Chicago, ILBuilt 1978 · S/N 28-7890486N3192CHansen Leland K · Phoenix, AZS/N R18200255N3192THawley James W · Waddell, AZBuilt 1967 · S/N 17700492N31932Air Cargo Solutions Inc · Two Rivers, AKBuilt 1973 · S/N 31-7405144N31933G & C Flying Inc · Litchfield, ILS/N 32R-7885142N31939Holt Thomas S · Layton, UTBuilt 2018 · S/N 1212N3194PGalindo Don R Jr · Walnut Grove, CABuilt 1980 · S/N 18-8009042N3194WNiehaus Properties Inc · Portland, ORBuilt 2006 · S/N 11173N3195Gorham Luke E · Wichita Falls, TXBuilt 2001 · S/N 4009N31950Kasparie Ronald · Quincy, ILBuilt 1978 · S/N 28R-7837259N3195ZMcgrady Chadwick Paxton · Glade Park, COBuilt 1959 · S/N 18-7191N31961Duncanson Scott Alexander · Grand Blanc, MIBuilt 1978 · S/N 32R-7887017N31969Chandelle Flying Club Inc. · Austin, TXBuilt 1978 · S/N 28-7890488N3196TNicholson Perry R · Merlin, ORBuilt 1968 · S/N 17700496N31977Wedekemper Donald E · Howell, MIBuilt 1978 · S/N 32R-7885148N3197TMundle Jeffrey A · Ashland, ORBuilt 1967 · S/N 17700497N3197ZSlayden Steven M · Rhome, TXBuilt 1959 · S/N 18-7195N31981Elusive Aviation Inc · Pflugerville, TXBuilt 1978 · S/N 32R-7887018N31985Ledge Aero Inc · Holt, MIBuilt 1978 · S/N 28-7816604N31988Little Dog Aviation LLC · Branchburg, NJBuilt 1978 · S/N 28-7816605N3198FDepinet Rodney J · Glen Saint Mary, FLBuilt 1968 · S/N 17256588N31995One Zero Tango LLC · Chattanooga, TNBuilt 1978 · S/N 32R-7885149N31996Seacoast Plane Partners LLC · Exeter, NHBuilt 1978 · S/N 32R-7885151N31998Lance Group LLC · Moab, UTBuilt 1978 · S/N 32R-7887019N3199TMortgage Experts LLC · Homestead, FLBuilt 1967 · S/N 17700499N319AZRegistered aircraftBuilt 1988 · S/N 1850N319CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881505N319DCBecker Dennis P · Kelso, WABuilt 2008 · S/N 23772N319ECRansom Robert W · Moorestown, NJBuilt 1994 · S/N 19032C
Back to AD 87-10-06 R1