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.

N7085WBinder Jeffrey K · Brazil, INBuilt 1962 · S/N 28-871N7087ACmcq Flight LLC · Park River, NDBuilt 1970 · S/N 28-26518N7087RSensabaugh Randall W · Stanton, TNBuilt 1966 · S/N 28-21790N7087WHill Corey · Douglas, ALBuilt 1962 · S/N 28-873N7088WMarshall Xavier T · Carson, CABuilt 1962 · S/N 28-875N7089RFlying Tigers Aviation LLC · Mars, PABuilt 1966 · S/N 28-21792N7090RMekolichick Jerry D · Whitehall, PABuilt 1966 · S/N 28-21793N7090WShipman Donald C · Interlochen, MIBuilt 1962 · S/N 28-877N7090YTucker Brandon · Rockledge, FLBuilt 1973 · S/N 28-7305058N7092RCosey William Vester Franklin · Inverness, FLBuilt 1966 · S/N 28-21796N7093RKearns Joseph E · Worthington, OHBuilt 1966 · S/N 28-21797N7094RWilson Flyers LLC · Rocky Mount, NCBuilt 1966 · S/N 28-21798N7095RStevens Aircraft LLC · Morehead, KYBuilt 1966 · S/N 28-21799N7095WByers Brady L · Newberg, ORBuilt 1962 · S/N 28-882N7096RHumphrey Richard K Jr · Abilene, TXBuilt 1966 · S/N 28-21800N7096WN7096w LLC · Sherman Oaks, CABuilt 1962 · S/N 28-883N7097RFields Michael L · Rockwood, TNBuilt 1966 · S/N 28-21802N7097WGlidepath Consulting LLC · Yuma, AZBuilt 1962 · S/N 28-884N7098WFarabee Mechanical Inc · Hickman, NEFirst renewal noticeBuilt 1962 · S/N 28-885N70CDLewis Cherrie · Hampton, CTBuilt 1969 · S/N 28-26542N7100Registered aircraftBuilt 1968 · S/N 28-4739N7100WKlein Jarmes Harold · Lino Lakes, MNS/N 28-887N7101WDobson Michael E · Columbus, OHS/N 28-888N7102WHower Nicholas J · Centerville, OHBuilt 1962 · S/N 28-889N7103WDunavin Joseph E · Menasha, WIBuilt 1962 · S/N 28-890N7104WRegistration Pending · Shelbyville, TNRegistration pendingBuilt 1962 · S/N 28-891N7105WDeibert Dale A · Herreid, SDBuilt 1962 · S/N 28-893N7106WGriffin Jim T · Tunnel Hill, GABuilt 1962 · S/N 28-894N7107WCaufield Dennis R · Carl Junction, MOBuilt 1962 · S/N 28-895N7108RChristian Mark A · South Point, OHBuilt 1966 · S/N 28-21805N7108WRed Rock Flying School LLC · Mesa, AZS/N 28-896N7109WV1 Air Inc · Hibbing, MNS/N 28-897N710RDPurll Samuel B · Mechanicsville, MDBuilt 1966 · S/N 28-21809N7110RQuale Eric L · Everett, WABuilt 1966 · S/N 28-21806N7111RGreen Michael W · Helena, ARS/N 28-21810N71128Eastern Stearman Inc Trustee · Leesburg, VABuilt 1972 · S/N 28-7225450N7112RMarshall Air LLC · Bellevue, MIBuilt 1966 · S/N 28-21811N7112WKeesee Bill · Meadow, TXBuilt 1962 · S/N 28-903N7113RNewton Dennis E · Surprise, AZBuilt 1966 · S/N 28-21812N7113WHigh Flyers Inc · Benson, AZS/N 28-961N7114WEstes Shannon L · Pace, FLBuilt 1962 · S/N 28-905N7115WLambert Scott E · Shamong, NJBuilt 1962 · S/N 28-906N7116RBastian Dennis L · Burns, WYBuilt 1966 · S/N 28-21816N7117WMitchell Cameron A · Hopkinsville, KYBuilt 1962 · S/N 28-908N711BDCoburn Eric E · Leesburg, INFirst renewal noticeBuilt 1972 · S/N 28-7205271N711FLFernandez Kevin · Fuquay Varina, NCBuilt 1972 · S/N 28-7225327N7122RSimmons Heating And Air Conditioning LLC · Summerville, SCBuilt 1966 · S/N 28-21823N7123WHarvick Wayne P II · Kenmore, WABuilt 1962 · S/N 28-920N7124RNewsome Thomas D · Canal Winchester, OHBuilt 1966 · S/N 28-21825N7124WTuchols John E · Lockport, NYBuilt 1962 · S/N 28-921
Back to AD 96-10-01 R1