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.

N6592WChait Braeden Abraham · Vancouver, WAS/N 28-20681N6593JRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1968 · S/N 28-5053N6594JHub City Aviation Academy LLC · Lubbock, TXBuilt 1968 · S/N 28-5054N6596WN6596w LLC · Derby, KSBuilt 1965 · S/N 28-20686N6598JThatcher Bruce Lyall · Shorewood, MNBuilt 1968 · S/N 28-5057N6599JCormack Matthew S · Chandler, AZBuilt 1968 · S/N 28-5058N659FLHudacko Daniel M · Saint Cloud, FLFirst renewal noticeS/N 28-7125577N65RJAdvantage Flight Training And Services LLC · Warren, ARBuilt 1965 · S/N 28-2599N6601JRobinson John H · Kernersville, NCBuilt 1968 · S/N 28-5061N6601WAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 28-20692N6602JD14 Flight Club Inc · Manteno, ILBuilt 1968 · S/N 28-5062N6602YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 28-21943N6603JWorkman Karen L · Northfield, MNBuilt 1968 · S/N 28-5063N6604WSedberry Jason A · Kokomo, INBuilt 1965 · S/N 28-20697N6605JPatton Janet · Denton, TXBuilt 1968 · S/N 28-5066N6605WChadwick Joseph G · Fayetteville, GABuilt 1965 · S/N 28-20698N6606JSale Reported · Warner Robins, GASale reported, canceledBuilt 1968 · S/N 28-5067N6606WMobley Ray M Jr · Midlothian, TXS/N 28-20700N6608JGreat Lakes Aviation Services Inc · Kimball, MIBuilt 1968 · S/N 28-5070N6608WGrant Hooks LLC · Middleburg, FLBuilt 1965 · S/N 28-20702N6610JSaracoff Norman L · Neillsville, WIBuilt 1968 · S/N 28-5072N6610WHattersley Donald C · York, SCBuilt 1965 · S/N 28-20704N6611WBryant Bryce Nicholas · Crothersville, INBuilt 1965 · S/N 28-20705N6613WBanks Jeffrey G · Columbus, OHBuilt 1965 · S/N 28-20707N6615JAeropenn Aviation Academy LLC · Paxinos, PAS/N 28-5079N6615WLoughridge Steven L · Montezuma, OHBuilt 1965 · S/N 28-20710N6616JBrack Enterprises LLC · Indianapolis, INBuilt 1968 · S/N 28-5081N6618WLe Ariya · La Crosse, WIBuilt 1965 · S/N 28-20713N6619JBjelland Nathan D · Phoenix, AZBuilt 1968 · S/N 28-5085N661FLS B Enterprise LLC · Marshall, TXBuilt 1971 · S/N 28-7125581N6621JMardis David P · Warner Robins, GABuilt 1968 · S/N 28-5087N6621WGbg Aviation LLC · Foristell, MOBuilt 1965 · S/N 28-20717N6622JBernstein Matthew D · North Charleston, SCBuilt 1968 · S/N 28-5089N6622WBayko John T · Marengo, OHBuilt 1965 · S/N 28-20718N6623JAcadian Aviation Pilot Training Centre Inc · Lafayette, LAS/N 28-5090N6624JN6624 LLC · Reserve, LABuilt 1968 · S/N 28-5091N6625JJustice Andrew C · Amory, MSBuilt 1968 · S/N 28-5092N6625WR W Bright Architects Inc · Tulsa, OKBuilt 1965 · S/N 28-20722N6626JSn Aviation LLC · Richardson, TXBuilt 1968 · S/N 28-4919N6627JYellowstone Flying Club · Billings, MTBuilt 1968 · S/N 28-4927N6627WSemprimoznik Jeffery J · Davenport, WABuilt 1965 · S/N 28-20724N6628WFigueroa Ruben E · Las Vegas, NVBuilt 1965 · S/N 28-20725N6629WWilcox Chris M · Canajoharie, NYBuilt 1965 · S/N 28-20726N6630WRiggin Flight Service Inc · Madison, SDS/N 28-20728N6631WRegistration Pending · Arbela, MORegistration pendingBuilt 1965 · S/N 28-20729N6633JBailey Randall D · Oakley, MIS/N 28-5099N6633WSyf LLC · Okmulgee, OKBuilt 1965 · S/N 28-20731N6634JMaier Robert B · Duncanville, TXBuilt 1968 · S/N 28-5101N6635JIndian Head Flying Club LLC · Indian Head, MDBuilt 1968 · S/N 28-5102N6637JCaison Rodney D · Carrollton, VABuilt 1968 · S/N 28-5105
Back to AD 96-10-01 R1