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.

N8882JWisian Hans C · Boerne, TXBuilt 1965 · S/N 28-2855N8883JRegistration Pending · Midlothian, TXRegistration pendingBuilt 1965 · S/N 28-2857N8883NWarner Alexander Douglas · Grand Rapids, MIBuilt 1969 · S/N 28-25749N8884NDubois Jerry · Oklahoma City, OKBuilt 1969 · S/N 28-25750N8885JWeise David D · Marion, TXBuilt 1965 · S/N 28-2859N8887JWeskap LLC · West Grove, PABuilt 1965 · S/N 28-2862N8888JSnapp Steve J · Los Alamos, NMS/N 28-2863N888AWCag International Inc DBA · Longmont, COBuilt 1973 · S/N 28-7305386N888BWAero Elite Inc · Wilmington, DEBuilt 1970 · S/N 28-5856N888ERFrost Aviation Alliance LLC · Tampa, FLBuilt 1974 · S/N 28-7505087N888ZGNess Aviation LLC · Moriarty, NMBuilt 1974 · S/N 28-7525109N8890JBlease Ronald B II · Moultrie, GABuilt 1965 · S/N 28-2865N8890KFgds Aviation LLC · North Fort Myers, FLBuilt 1967 · S/N 28-23761N8891JAdamson Steven C · Stockbridge, GABuilt 1965 · S/N 28-2866N8891NAlred Steven J · Centre, ALBuilt 1969 · S/N 28-25755N8892JA&R Aviation LLC · Houston, TXBuilt 1965 · S/N 28-2867N8893JWare Wilson · Rockwall, TXS/N 28-2868N8894JMenees B Martin · Little Rock, ARBuilt 1965 · S/N 28-2870N8895JCherokee N8895j Inc · Westminster, MDBuilt 1965 · S/N 28-2871N8895NLuque Michael J · Shinnston, WVS/N 28-25759N8896EN8896e LLC · Lake City, FLBuilt 1976 · S/N 28-7625165N8896JClark Kenneth A · Mount Pleasant, ARBuilt 1965 · S/N 28-2872N8897JShreve Gene · Fayetteville, TNBuilt 1965 · S/N 28-2873N8897NAnderson Leroy H · San Angelo, TXBuilt 1969 · S/N 28-25761N8898JColt 45 LLC · Tulsa, OKS/N 28-2874N8898NTaylor Danny H · Defuniak Springs, FLBuilt 1969 · S/N 28-25762N88FNSaline County Flyers Association LLC · Little Rock, ARBuilt 1969 · S/N 28-26119N8901JQuinn Andrew · Fort Worth, TXBuilt 1965 · S/N 28-2878N8902JLeavitt Jason R · Barnstead, NHBuilt 1965 · S/N 28-2880N8904JHenderson John · Kirksville, MOBuilt 1965 · S/N 28-2882N8909Registration Pending · Stockton, CARegistration pendingBuilt 1967 · S/N 2823008N8909JJenson Adam D · Duluth, MNBuilt 1965 · S/N 28-2890N890BVJefferies James A Trustee · Peck, KSBuilt 1973 · S/N 28-7305215N8912JSoar With Sophia LLC · South Lyon, MIBuilt 1965 · S/N 28-2894N8914JVesper Aviation LLC · Las Vegas, NVBuilt 1965 · S/N 28-2929N8917JI Was Inverted LLC · Fort Myers, FLS/N 28-2932N8919JKelly Kevin R · Ormond Beach, FLBuilt 1965 · S/N 28-2935N891GPHancock Aircraft Sales LLC · Baton Rouge, LABuilt 1967 · S/N 28-23847N8920JSargent Timothy E · Pickerington, OHBuilt 1965 · S/N 28-2937N8922JTowner Jeffery D · Rose Hill, KSBuilt 1965 · S/N 28-2939N8923JVenture West LLC · Mesa, AZBuilt 1965 · S/N 28-2940N8926JGreene Ronald F · Mc Alpin, FLBuilt 1965 · S/N 28-2944N8927JTipton Thomas G · Walnut Grove, MOS/N 28-2945N8928JHaybron David M · Sewickley, PABuilt 1965 · S/N 28-2946N8929JRice Spencer F · Portland, ORBuilt 1965 · S/N 28-2947N8930JMccracken Blake R · Lake Havasu City, AZBuilt 1965 · S/N 28-2948N8933JQuilling John R · Cannon Falls, MNBuilt 1965 · S/N 28-2950N8936JCloud Niners Inc · Brownsburg, INBuilt 1965 · S/N 28-2953N8938JMeier Daniel J · Greenwood, INBuilt 1965 · S/N 28-2955N8939JEstis Jonathan D · Walden, NYBuilt 1966 · S/N 28-2956
Back to AD 96-10-01 R1