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.

N6952WBeaver Milton H II · Palmer, AKBuilt 1965 · S/N 28-21143N6953WScotting David R · Pipestone, MNBuilt 1965 · S/N 28-21144N6958WPeck Michael S · Las Vegas, NVBuilt 1965 · S/N 28-21150N695FLPugh Daniel J · Omaha, NEBuilt 1971 · S/N 28-7125634N6961WExpresstek LLC · Farmington, UTBuilt 1965 · S/N 28-21155N6962JBores Scott J · Huron, OHBuilt 1976 · S/N 28-7625262N6962WStalnaker Stanley A · Tifton, GABuilt 1965 · S/N 28-21156N6963WNash Larry A · Rockport, MABuilt 1965 · S/N 28-21158N69641Burke Jason C · Juneau, AKS/N 28-7325602N6964WKuss John D · Webster, NYBuilt 1965 · S/N 28-21161N6965WSitaras Evangelos · Ladonia, TXBuilt 1965 · S/N 28-21162N6966WYoumans Elbert Mitchell · Waynesboro, GABuilt 1965 · S/N 28-21163N6967WBengis Adam · Seattle, WABuilt 1965 · S/N 28-21164N6968WMidgard Aviation LLC · Colton, SDBuilt 1965 · S/N 28-21165N6969WJones Robert · Winter Haven, FLBuilt 1965 · S/N 28-21166N696FLGood Joseph A · Weymouth, MABuilt 1971 · S/N 28-7125635N696LBN&C Aviation LLC · Niles, MIBuilt 1964 · S/N 28-20136N6971JMurphy David Charles · Rancho Cucamonga, CABuilt 1976 · S/N 28-7625263N6971WPop-A-Top Corp · Nashville, MIBuilt 1965 · S/N 28-21169N6972WPryce James T · Ebensburg, PABuilt 1965 · S/N 28-21170N6974WRolland Jason J · Plumas Lake, CABuilt 1965 · S/N 28-21172N6976WHorst Paul N · Lebanon, PAFirst renewal noticeBuilt 1965 · S/N 28-21174N6979WCzygan Noel · Rapid River, MIBuilt 1965 · S/N 28-21177N697YAHorizon Flyers LLC · Kingsford, MIBuilt 1971 · S/N 28-7125636N6981WHammontree David M · Rickman, TNS/N 28-21179N6982WMoran Erick A · Orange, CAS/N 28-21292N6983WTuttle James M · Newell, IABuilt 1965 · S/N 28-21181N6988WLowe-Wing Aviation Inc · Wilmington, DEBuilt 1965 · S/N 28-21186N6989WCarter Johnny W · Crawford, TXBuilt 1965 · S/N 28-21188N698FLNight Fox Aircraft LLC · Mesa, AZBuilt 1971 · S/N 28-7125638N6990WMadichar LLC · Lempster, NHBuilt 1965 · S/N 28-21189N6991WCarnes James Oscar Jr · Smiths Grove, KYS/N 28-21190N6994JLytle Tobin A · Grove, OKBuilt 1976 · S/N 28-7625266N6994WCone Carl T · Statesboro, GABuilt 1965 · S/N 28-21193N6996WGiles David · Augusta, GABuilt 1965 · S/N 28-21195N6997WKeeter Michael P · Proberta, CABuilt 1965 · S/N 28-21196N6998WTutunik Aleksandr · Lake Hughes, CAS/N 28-21197N6999WSilva Javier · Sanger, TXBuilt 1965 · S/N 28-21198N699FLEdgewood Acres LLC · Willmar, MNS/N 28-7225193N69APScott Brady · Manakin-Sabot, VABuilt 1969 · S/N 28-25658N69KYAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N 28-7305300N6FGSmith Timothy S · Kinston, NCBuilt 1974 · S/N 28-7425297N6MRBeezyflyin LLC · Chesapeake, VABuilt 1972 · S/N 28-7205270N6NHStephens Timothy D · Springfield, MOBuilt 1966 · S/N 28-3698N7000RJilek Peter Andrew · River Falls, WIBuilt 1966 · S/N 28-21693N7000WIndy Air Sales LLC · Anderson, INBuilt 1962 · S/N 28-671N7001WBrinc LLC · Lancaster, PABuilt 1963 · S/N 28-673N7004REasley Leroy · Novelty, MOFirst renewal noticeBuilt 1966 · S/N 28-21698N7004WLettsome Nesco · Beltsville, MDBuilt 1962 · S/N 28-676N7007JKeltner Kody M · Meadville, PAS/N 28-3162
Back to AD 96-10-01 R1