OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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.

N55497Murphy David B · Germantown, MDBuilt 1973 · S/N 28-7325419N55498Burke Monte D · Dallas, TXBuilt 1973 · S/N 28-7325420N5549UFar From Cheap LLC · Wichita Falls, TXBuilt 1969 · S/N 28-26273N5549WFons Wlliam M · Oconomowoc, WIBuilt 1962 · S/N 28-640N554FLTomenyaero Inc · Florence, ORS/N 28-7125393N554PAGerken Nicholas C · Anacortes, WABuilt 1972 · S/N 28-7225475N55502Blue Valley Flying Club Inc · Denton, NES/N 28-7305401N55504University Cherokee Club LLC · Lincoln, NEBuilt 1973 · S/N 28-7305402N55505Bothwell Brandon W · Mooresville, MOS/N 28-7305403N55506Lugo Rullan Javier A · Adjuntas, PRBuilt 1973 · S/N 28-7325424N5550UFarm Air Service Inc · Pingree, NDBuilt 1969 · S/N 28-26274N5550WStone Oren · Erick, OKS/N 28-641N55513Spoon River Flyers Inc · Avon, ILBuilt 1973 · S/N 28-7305405N55514Loomis Christopher · Cumming, GABuilt 1973 · S/N 28-7305406N5551FFriest Eric J · Menomonie, WIBuilt 1968 · S/N 28-24890N5551WMurdter Lawrence M · Sunnyvale, CABuilt 1962 · S/N 28-642N55525Gustafson Michael Luther · Groveland, CABuilt 1973 · S/N 28-7325426N55529Carrozzella Christopher · Wallingford, CTS/N 28-7305407N5553UMcdonough Brian E · Harrisburg, PABuilt 1969 · S/N 28-26278N55542Colorado Cherokee Flyers LLC · Boulder, COBuilt 1973 · S/N 28-7325429N5554DValiair Limited Company Trustee · Casper, WYBuilt 1965 · S/N 28-2228N5554EValiair Limited Company Trustee · Casper, WYBuilt 1977 · S/N 28-7725152N5554UNeeley Stephan B · Dighton, KSBuilt 1969 · S/N 28-26279N5554WFlyworx LLC · Kalispell, MTBuilt 1962 · S/N 28-646N55551Mahmud Fawzi S · Enid, OKBuilt 1973 · S/N 28-7325328N55558Wagner Mark · Medina, WABuilt 1973 · S/N 28-7325368N55559Mcconnachie Craig · Bullhead City, AZBuilt 1973 · S/N 28-7305392N5555AGellner Sy D · Billings, MTS/N 28-860N5555WLemieux Patrick · San Luis Obispo, CABuilt 1962 · S/N 28-647N55563Sanchez Alejandro Arturo · El Paso, TXBuilt 1973 · S/N 28-7325433N55564Moore Ryan J · Corvallis, ORBuilt 1973 · S/N 28-7305414N55565Brickweg Kurt J · Cincinnati, OHBuilt 1973 · S/N 28-7305415N5556UCynthiana Flying Group Corp · Cynthiana, KYBuilt 1969 · S/N 28-26282N55578Gardiner Merrill L · Traverse City, MIBuilt 1973 · S/N 28-7325435N55585Kankakee Area Flying Group LLC · Gilman, ILBuilt 1973 · S/N 28-7305418N5558FConner Brad S · Waynesville, OHBuilt 1968 · S/N 28-24898N5558WPatterson Troy V · Arlington, TXS/N 28-650N55593Flying Life LLC · Fuquay Varina, NCBuilt 1973 · S/N 28-7305400N55596Outdoor Products Of Louisiana LLC · Heflin, LAS/N 28-7325439N55597Arndt Douglas E · Marion, WIBuilt 1973 · S/N 28-7305421N55598Smith Gregory E · Manila, ARS/N 28-7305422N5559FEsteban Granwel · Johnson City, TNBuilt 1968 · S/N 28-24899N555AZN555az LLC · Herndon, VABuilt 1969 · S/N 28-26585N555EEKielich Darryl C · Knights Landing, CABuilt 1968 · S/N 28-24888N555FLD&J Aviation LLC · Apopka, FLBuilt 1971 · S/N 28-7125394N555PAPyle Dana C · Naples, FLBuilt 1972 · S/N 28-7225476N555PBM5 LLC · Kit Carson, COBuilt 1973 · S/N 287305016N555TWMccabe Robert J Trustee · Cherry Hill, NJBuilt 1973 · S/N 28-7305578N555UMBoretide Aviation LLC · Anchorage, AKBuilt 1971 · S/N 28-7105078N555VCBassetti Cody J · Paso Robles, CABuilt 1969 · S/N 28-26049
Back to AD 96-10-01 R1