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.

N32700Mob Aviation USA LLC · Auburndale, FLBuilt 1974 · S/N 28-7525099N32703Venture West LLC · Mesa, AZBuilt 1974 · S/N 28-7505084N32704Hobson Martin G · Loomis, CABuilt 1974 · S/N 28-7505085N32711Three Rivers Aero LLC · Three Rivers, MIBuilt 1974 · S/N 28-7525102N32714Meringer Ronald Eduardo · Phoenix, AZBuilt 1974 · S/N 28-7505086N32739Beneke Mark N · Bushton, KSBuilt 1974 · S/N 28-7525105N32767James Stanley C · Palmer, AKS/N 28-7525110N32794Gilbert Thomas D · Gladstone, MIBuilt 1974 · S/N 28-7505094N32801Registration Pending · Indianapolis, INRegistration pendingBuilt 1971 · S/N 28-7525117N32805Scheffler Frederick L · Corinth, KYBuilt 1974 · S/N 28-7525115N32825Manning John E Jr · Sylacauga, ALBuilt 1974 · S/N 28-7525118N3282QMaxwell Benjamin D · Collierville, TNBuilt 1977 · S/N 28-7725221N32830Mach One Over Six LLC · Atlanta, GABuilt 1974 · S/N 28-7505097N32837Arias Aviation LLC · Hazle Township, PABuilt 1974 · S/N 28-7525120N32838Brawders Stephen Andrew · Simi Valley, CABuilt 1974 · S/N 28-7525121N32860Schroeder Scott · Decatur, TNS/N 28-7505099N32874Strawberry Aviation Inc · Watsonville, CABuilt 1974 · S/N 28-7525125N3287QJase Aircraft Leasing LLC · Lenexa, KSBuilt 1977 · S/N 28-7725222N32898Spitaleri Robert F · Winter Haven, FLS/N 28-7525126N32971Umbdenstock Jerry R · Thermopolis, WYBuilt 1974 · S/N 28-7505106N32993N32993 LLC · Provo, UTBuilt 1975 · S/N 28-7505108N329LTango Aviation Rentals LLC · Austin, TXBuilt 1967 · S/N 28-23574N32JLSanson William P Jr · Dodge Center, MNBuilt 1967 · S/N 28-4391N32SAAmoretti Remor Vinicius · Gardena, CABuilt 1977 · S/N 28-7725174N33001Peak Builders Inc · San Diego, CAS/N 28-7525134N33030Fanopoulos Joshua J · Boise, IDS/N 28-7525139N33046American Eagles Flying Club · New Hudson, MIBuilt 1975 · S/N 28-7505114N33061Piper 33061 LLC · Rustburg, VABuilt 1975 · S/N 28-7505116N33064Facklair LLC · Granville, OHS/N 28-7505117N33077Klug Ryan Gregory · Lincoln, NEBuilt 1975 · S/N 28-7525149N33079Devaney Aviation Inc · Palm City, FLS/N 28-7525150N33081Tofan Ray · Chula Vista, CAS/N 28-7505119N33083Barnhill Chris · Carbondale, ILBuilt 1975 · S/N 28-7505120N33092Shepherd Edward H · Grass Valley, CABuilt 1975 · S/N 28-7525153N33107Florida Coastal Flying Club LLC · Titusville, FLBuilt 1975 · S/N 28-7525154N33121Civil Air Patrol Flying Association Inc · Branford, CTBuilt 1975 · S/N 28-7505124N33128Flora Airport Authority · Flora, ILBuilt 1975 · S/N 28-7505125N33138Ables John M · Tehachapi, CABuilt 1975 · S/N 28-7525161N33147Johann Austin J · Richland Center, WIS/N 28-7525163N33150Iowa County Flying Club Inc · Mineral Point, WIBuilt 1975 · S/N 28-7505127N33158Mc Aviation LLC · Paducah, KYBuilt 1975 · S/N 28-7525164N33161Fca Flight Training LLC · Washington C H, OHS/N 28-7525165N33170Atlanta Sky Signs LLC · Sharpsburg, GABuilt 1975 · S/N 28-7505129N331WTillman Nickolas R · Piggott, ARBuilt 1972 · S/N 287225543N331WBAb Aviation LLC · Ashland, OHBuilt 1969 · S/N 28-5401N3328QEastman John T · Winfield, KSBuilt 1977 · S/N 28-7725223N332NDRapier Kenneth · Chicago, ILBuilt 1969 · S/N 28-26021N33304Ellis Tom J · Chandler, AZBuilt 1975 · S/N 28-7525168N3330RJph Incorporated · Kokomo, INBuilt 1970 · S/N 28-5659N33313Larson Laurinda P · Hubert, NCBuilt 1975 · S/N 28-7525170
Back to AD 96-10-01 R1