OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N2673TZweig William D · Chesterfield, MOBuilt 1972 · S/N 28-E11N2673WAdolf Charles P · Ocala, FLBuilt 1966 · S/N 996N26743Lian Jay · Gold Beach, ORBuilt 1978 · S/N AA5A0686N26744Flying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0688N2674TCosgrove John W · Lake Ariel, PABuilt 1971 · S/N 28-7205075N2674WHough Publishing LLC · Atlanta, GABuilt 1966 · S/N 997N26757Terranova Jay · Lawrenceville, GAS/N AA5A0695N26758Cooley Carolyn A · Bonifay, FLBuilt 1978 · S/N AA5A0696N2675DPaige Barry Wayne · Wasilla, AKBuilt 1952 · S/N 20827N2675TMahoney Dustin G · Lakewood, COBuilt 1971 · S/N 28-7225084N26760Davis Dana J · Pismo Beach, CABuilt 1978 · S/N AA5A0699N26768Cheetah268 LLC · Kailua Kona, HIBuilt 1978 · S/N AA5A0704N2676TMills Nicolas A · Greenwood, NYBuilt 1971 · S/N 28-7205074N2676ZFlynn Steven W · Bushnell, FLBuilt 1977 · S/N 1008-78N26770Tuan Vo · Falls Church, VABuilt 1978 · S/N AA5A0705N26778N26778 LLC · Santa Monica, CABuilt 1978 · S/N AA5A0714N2677TDaggett Truck Lines Inc · Frazee, MNBuilt 1971 · S/N 28-7205077N2677WSaunders Charles A · Scott Depot, WVBuilt 1966 · S/N 3318N2677ZWillkris Aviation Services LLC · Smithfield, VAS/N 1018-78N26780Campbell Joseph · Niceville, FLBuilt 1978 · S/N AA5A0715N26781Landon Easton Jeffrey Allen · Dresden, TNBuilt 1978 · S/N AA5A0716N26784Texas Cheetah LLC · Sugar Land, TXS/N AA5A0717N26788Redwood Aircraft LLC · Santa Rosa, CABuilt 1978 · S/N AA5A0722N2678TTekforce LLC · Boca Raton, FLBuilt 1971 · S/N 28-7205078N2678WLansford Company Inc · Lampasas, TXBuilt 1966 · S/N 999N26792Mayer David J · Ingleside, ILBuilt 1978 · S/N AA5A0725N26793Registered aircraftBuilt 1978 · S/N AA5A0727N26794Seveca Ventures LLC · Arcola, TXBuilt 1978 · S/N AA5A0728N26796Rivers Robert W · Savannah, GABuilt 1978 · S/N AA5A0581N26799Barton Steve K · Canon City, COBuilt 1978 · S/N AA5A0734N267AAWings Over Texas Holdings LLC · Denton, TXBuilt 2019 · S/N 4496482N267AGSimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 28-7425114N267CMRegistered aircraftBuilt 1954 · S/N 18-3532N267DHInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28-8190141N267DPCarrasco Mario G · Glendora, CABuilt 1967 · S/N 28-22673N267GSArnold Airplane LLC · North Branch, MNBuilt 1994 · S/N 737-94N267JMMathews Development Co · Santa Rosa Beach, FLBuilt 1999 · S/N T20608132N267MSweetman Gary S · Wolcott, CTBuilt 2006 · S/N 90607N267MECape Aero LLC · Cape Girardeau, MOBuilt 2000 · S/N 18280774N267MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881365N267MTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1974 · S/N 0005N267NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842067N267RBLearn To Fly LLC · Portal, GABuilt 1967 · S/N 32-40261N267RWKoelzer Galen G · Othello, WABuilt 1964 · S/N 0047N267SNorth Carolina Soaring Association · Zebulon, NCBuilt 1969 · S/N 1486N267WSErvin Andrew · Centennial, COBuilt 1966 · S/N 1000N26800Registration Pending · Peyton, CORegistration pendingS/N AA5A0735N26805Barry Robert J · Gresham, ORBuilt 1978 · S/N AA5A0737N2680MRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1977 · S/N 28-7890261N2680QTaylor Clarence J · Pipestone, MNBuilt 1977 · S/N 32R-7780261
Back to AD 87-10-06 R1