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.

N9678JNegley Neil C · Newburg, PABuilt 1967 · S/N 28-3849N9678WDependable Aviation LLC · Cartersville, GABuilt 1967 · S/N 28-23146N9679WDnr Solutions LLC · Idaho Falls, IDS/N 28-23147N9680JAltizer Joseph F · West Logan, WVBuilt 1967 · S/N 28-3850N9680WConrady Colt · Laguna Niguel, CABuilt 1967 · S/N 28-23149N9682JLenz Frank M · Boca Raton, FLBuilt 1967 · S/N 28-3853N9682WCullen Clay T · Danbury, CTBuilt 1967 · S/N 28-23151N9683JDale Allyson K I · Clarkston, MIBuilt 1967 · S/N 28-3855N9683WHincy William P · Palmdale, CABuilt 1967 · S/N 28-23152N9684JBlackstone Aircraft LLC · Hartselle, ALBuilt 1967 · S/N 28-3856N9684WGousios Eleni E · Rocklin, CAS/N 28-23154N9686JPohl Andrew L · Zephyrhills, FLBuilt 1967 · S/N 28-3859N9686WRosenberry David D · Tucson, AZBuilt 1967 · S/N 28-23156N9688JUrban Jess A · Marysville, KSBuilt 1967 · S/N 28-3862N9689WRegistration Pending · Denver, CORegistration pendingBuilt 1967 · S/N 28-23160N968CAAmerican Aviator LLC · Arlington, TXBuilt 1965 · S/N 28-2130N9690KSantana Alexandre C · Long Beach, CAS/N 28-7625190N9690WCloud Catcher Aviation LLC · Great Falls, MTBuilt 1967 · S/N 28-23161N9691JSteinberg Matthew Robert · Wayne, NJBuilt 1967 · S/N 28-3880N9692JRegistered aircraftBuilt 1967 · S/N 28-3881N9693WDelaney Kevin P · Germantown, TNBuilt 1967 · S/N 28-23165N9694JEli Team 6 Air Services LLC · Madisonville, TNBuilt 1967 · S/N 28-3883N9694WBertsch Brian · Seeley Lake, MTS/N 28-23166N9695JVaughn Gary Petty · Sanger, TXBuilt 1967 · S/N 28-3884N9698JWalters Max D · Lamar, MOBuilt 1967 · S/N 28-3887N9698WCas Ltd · Swanton, VTBuilt 1967 · S/N 28-23171N9699JTrevino Alberto O · Vero Beach, FLBuilt 1967 · S/N 28-3888N969DBBristol David W · Sautee Nacoochee, GABuilt 1969 · S/N 28-26197N969SDThompson James R · Warren, OHS/N 28-7225045N96ELJimenez-Cruz Juan C · Mayaguez, PRBuilt 1966 · S/N 28-3615N96KMijangos Adrian E · Mary Esther, FLBuilt 1977 · S/N 28-7725269N9701WGlougie Robert M · Fresno, CABuilt 1967 · S/N 28-23175N9705JFjb Aviation LLC · Palestine, TXS/N 28-3895N9707WBulger Edward P · Amesbury, MABuilt 1967 · S/N 28-23182N9708JGautsch Michael J · Onalaska, WIBuilt 1967 · S/N 28-3899N9709KLkn Cherokee LLC · Mooresville, NCBuilt 1976 · S/N 28-7625191N9709WStewart Glen W · Lebanon, TNBuilt 1967 · S/N 28-23184N9710JThompson Stephen N · Hagerman, IDBuilt 1967 · S/N 28-3901N9711WChapman Darren P · Winter Haven, FLBuilt 1967 · S/N 28-23186N9712JBowers Nicholas M · Mount Hope, WIBuilt 1967 · S/N 28-3903N9713WGiles Robert L · Columbia, SCBuilt 1967 · S/N 28-23189N9715JFly By Faith LLC · Laurel Springs, NCBuilt 1967 · S/N 28-3906N9717JCook Gardner · Sonoma, CABuilt 1967 · S/N 28-3908N971CCarol Corp · Lincoln, NEFirst renewal noticeBuilt 1964 · S/N 28-20093N971SEBrown Robert G · Tucson, AZBuilt 1969 · S/N 28-25492N9720JSouthern Cloudcruisers LLC · Lexington, NCBuilt 1967 · S/N 28-3912N9720WCarnahan Thomas W J · Independence, MOBuilt 1967 · S/N 28-23197N9721JSf Health Solutions Inc · Homestead, FLBuilt 1967 · S/N 28-3913N9721WCarson Bradley · Shippensburg, PAS/N 28-23199N9722JRegistration Pending · Missoula, MTRegistration pending, pending cancellationBuilt 1967 · S/N 28-3914
Back to AD 96-10-01 R1