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.

N2830TThree Zero Tango Corporation · Wentzville, MOBuilt 1972 · S/N 28-7205229N2836TRegistered aircraftBuilt 1972 · S/N 28-7225245N2837THuffman Jacob M III · Burleson, TXBuilt 1972 · S/N 28-7225246N283PWings Flight Group LLC · Las Vegas, NVBuilt 1968 · S/N 28-24802N2840TDuval Daniel · Hohenwald, TNBuilt 1972 · S/N 28-7205230N2846TEdjs Holdings LLC · Gladewater, TXBuilt 1972 · S/N 28-7225251N2848TMassey Howard W Jr · Wills Point, TXBuilt 1972 · S/N 28-7205231N284PReeves Robert E · Lagrange, GABuilt 1968 · S/N 28-24803N2859TGouda Rafik M · Rancho Cucamonga, CABuilt 1972 · S/N 28-7225254N285PDennin Michael E · Minden, LABuilt 1968 · S/N 28-24804N2860TSchmitz Nicholas S · East Lyme, CTBuilt 1972 · S/N 28-7205232N2866TPacific Coast Air Museum · Santa Rosa, CAS/N 28-7225258N2867TN504fl LLC · Killeen, TXBuilt 1972 · S/N 28-7225259N2868TBooth Gregory · Ferriday, LAFirst renewal noticeBuilt 1972 · S/N 28-7205233N2876TGear Up Aircraft Rental LLC · Warner Robins, GABuilt 1972 · S/N 28-7225261N287PN8297n LLC · Evansville, INBuilt 1968 · S/N 28-24806N2883TGolembiewski William · Hookstown, PABuilt 1972 · S/N 28-7225265N2884TBonner John A · Riverside, CABuilt 1972 · S/N 28-7225266N2886TAtkins Joseph Van · Lenoir, NCBuilt 1972 · S/N 28-7225268N2887TSanetra George W · Gary, INBuilt 1972 · S/N 28-7225269N288FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-23767N288GHBowen Christina M · Shreveport, LAS/N 28-1938N2891TVagias Janet Rose · Niceville, FLBuilt 1972 · S/N 28-7225270N2892TScherman Dale M · Ottertail, MNBuilt 1972 · S/N 28-7225272N2898TR P M Flying Club Inc · South Holland, ILS/N 28-7225275N2899TLessley Aviation LLC · Winona, MSBuilt 1972 · S/N 28-7225276N28CFDonavanik Daniel · Newark, DEBuilt 1972 · S/N 28-7305093N28FFCaicedo David · Villa Rica, GABuilt 1962 · S/N 28-208N28LArkad Ventures LLC · Coral Gables, FLS/N 28-20841N28NBBeckwith James N · Goldsboro, NCBuilt 1969 · S/N 28-26157N28NDN28nd LLC · Ambrose, GABuilt 1968 · S/N 28-4621N28NZNzaviation LLC · Mesa, AZBuilt 1973 · S/N 28-7305003N28PABurke Jacob R · Cornelius, NCS/N 28-3410N28QWBack Mark D · Washington, DCBuilt 1974 · S/N 28-7425223N28RAStires Steven D · Germantown, TNBuilt 1964 · S/N 28-20510N28SKAdamski Walter E Sr · Auburndale, FLBuilt 1968 · S/N 28-24940N28WTHangar 14 Maintenance Solutions LLC · Santa Teresa, NMFirst renewal noticeS/N 28-2288N290HADon'T Call Me Shirley LLC · Fort Myers, FLBuilt 1966 · S/N 28-3624N291HAChandler Air Service Inc · Chandler, AZBuilt 1966 · S/N 28-22138N2920WBrown Jeffrey C · Bozeman, MTBuilt 1965 · S/N 28-2435N292EHGlorybe2 LLC · Saluda, SCBuilt 1965 · S/N 28-20943N293RLCunningham Clinton · Kissimmee, FLBuilt 1975 · S/N 28-7505126N294SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 28-1258N294TWLouris Thomas W · Lake Oswego, ORBuilt 1965 · S/N 28-2202N295DAJackson Construction LLC · Charleston, SCBuilt 1968 · S/N 28-24582N298PWMedina Ruben F · Foothill Ranch, CABuilt 1965 · S/N 28-20851N29LCareer Flyers LLC · Crittenden, KYBuilt 1966 · S/N 28-22418N29NAGula Jason · Scranton, PABuilt 1969 · S/N 28-26246N29NCBeasley Fred Scott · Tulsa, OKBuilt 1967 · S/N 28-4277N2DARask Mark C · Becker, MNBuilt 1967 · S/N 28-23401
Back to AD 96-10-01 R1