OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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:96-10-01-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:96-10-01-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.

N15860Baker Stephen J · Surprise, AZBuilt 1972 · S/N 28-7305165N15861Registration Pending · Traverse City, MIRegistration pendingBuilt 1972 · S/N 28-7305167N15868Mogan & White Inc · New York, NYBuilt 1972 · S/N 28-7325182N15871Atlaspar Aviation Group LLC · Lenoir City, TNBuilt 1972 · S/N 28-7305168N15873Miller Robert B · Davenport, FLBuilt 1972 · S/N 28-7305169N15875Cjb Investments22 LLC · Holly Hill, FLBuilt 1972 · S/N 28-7305171N15881Ruhnke James · Houston, TXBuilt 1972 · S/N 28-7305173N15882Ellwood David A · Cambridge, OHBuilt 1972 · S/N 28-7305174N15888Quimbayo Ligia I · Homestead, FLBuilt 1972 · S/N 28-7325189N1588JLampe Mark E · Minnetonka, MNBuilt 1967 · S/N 28-23997N15892Registered aircraftBuilt 1972 · S/N 28-7305177N1590JTidwell Kevin C · Kennesaw, GABuilt 1967 · S/N 28-23999N15914Studt Joseph Floyd · Rockvale, COBuilt 1972 · S/N 28-7325197N15916Marianas Air Transfer Inc · Tinian, MPBuilt 1972 · S/N 28-7325199N15918Ramseier Peter A · Imperial Beach, CAS/N 28-7305185N1591JWingard Edward J · Powell, OHBuilt 1968 · S/N 28-24001N159274dw Interests LLC · Longview, TXBuilt 1973 · S/N 28-7325202N15928Bussell Matthew W · Reno, NVBuilt 1973 · S/N 28-7305187N15929Cs Flying Ltd · Grafton, OHBuilt 1972 · S/N 28-7305188N15930Rogers Aviation LLC · Florence, SCBuilt 1973 · S/N 28-7305189N15933Flaps Inc · White Bear Lake, MNBuilt 1973 · S/N 28-7325203N15935Stahl Dennis E · Wood Dale, ILBuilt 1973 · S/N 28-7305190N15936Brown Norman C · Kewanee, ILS/N 28-7305191N1593JRindeikis Bron · Sugar Grove, ILS/N 28-24003N15943Edgerton Eddie Lee · Midwest City, OKBuilt 1973 · S/N 28-7325208N15944Habit Samuel P · Kokomo, INBuilt 1973 · S/N 28-7305193N15945Newton Flying Club Inc · Collinsville, MSBuilt 1972 · S/N 28-7305194N15946Leading Edge Inc · Cottonwood Heights, UTBuilt 1973 · S/N 28-7305195N15955Air Wings Enterprise LLC · Roca, NEBuilt 1973 · S/N 28-7325210N15956Hanson Mark E · Griffin, GABuilt 1973 · S/N 28-7305196N15957Jones John E Jr · Metter, GABuilt 1973 · S/N 28-7305197N15962Romero Jason Nathanial · Broken Arrow, OKS/N 28-7325213N15966Acosta Aaron · El Paso, TXBuilt 1973 · S/N 28-7325214N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200N1596JWard Lawrence G · Mckenzie, ALBuilt 1941 · S/N 28-24007N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203N1597JLs Aviation LLC · Searcy, ARS/N 28-24008N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009N15994Self Thomas C · Madisonville, TNS/N 28-7325222N15997Stockman Greg · Allenton, MIBuilt 1973 · S/N 28-7305210N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245N15BCWingsleasing LLC · Wichita, KSBuilt 1964 · S/N 28-1712N160RFYank-N-Bank LLC · Greeley, COBuilt 1966 · S/N 28-21867N160TPContrail Aviation Inc · Cheboygan, MIBuilt 1963 · S/N 28-796N161SWLober Cameron K · Matthews, NCBuilt 1966 · S/N 28-3752N16244Oakland William S · New Port Richey, FLBuilt 1973 · S/N 28-7305211N162505b Aviation LLC · Duncan, OKBuilt 1973 · S/N 28-7305212
Back to AD 96-10-01 R1