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.

N7287WLebouef Kelly J · Rayne, LABuilt 1963 · S/N 28-1131N7288FJ&S Aeronautics LLC · Mcgregor, TXBuilt 1968 · S/N 28-25202N7288WIndependence Youth Flying Club Inc · Independence, ORBuilt 1963 · S/N 28-1132N7289JValdez Jose C · Troy, MIBuilt 1968 · S/N 28-24641N7289WHarris Clark R · Tribune, KSBuilt 1963 · S/N 28-1133N728FLFalcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedS/N 28-7225448N7290JPiper Nicolas A M · Atherton, CABuilt 1968 · S/N 28-24642N7291FTusing Richard C · Newell, SDBuilt 1968 · S/N 28-25205N7291JCenterline Equipment Corp · Waukegan, ILBuilt 1968 · S/N 28-24643N7291WKiser Eugene A · Sheboygan, WIBuilt 1963 · S/N 28-1357N7292FAalderks Roger H · Blomkest, MNBuilt 1968 · S/N 28-25207N7292JCapital Region Aviation Partners Inc · Troy, NYBuilt 1968 · S/N 28-24645N7293JFuller Jaime E · Walnut Cove, NCBuilt 1968 · S/N 28-24647N7294JForsyth Matthew J · Fayetteville, GABuilt 1968 · S/N 28-24649N7294WCapstone Aviation LLC · Lancaster, CABuilt 1963 · S/N 28-1139N7295JHaass Susan D Teese · Cypress, TXBuilt 1968 · S/N 28-24650N7297JPearce Jim R · Stratford, TXBuilt 1968 · S/N 28-24652N7297WTurner Joseph N · Chuckey, TNBuilt 1963 · S/N 28-1150N7298FAgostini Joseph L · Broomall, PABuilt 1969 · S/N 28-25212N7298JNapper Kenneth L · Sacramento, CABuilt 1968 · S/N 28-24653N7298WSchnitiker Allan A · Pratt, KSS/N 28-1151N7299FGardner Todd D · Poland, INS/N 28-25206N7299WBugner David J · Savannah, GABuilt 1963 · S/N 28-1121N729DRowe Perry D · Mccall, IDS/N 28-2930N729FLFlight Adventures Llp · Pleasant Grove, UTBuilt 1972 · S/N 28-7225488N72CDG Brinkman Aviation Inc · Naperville, ILBuilt 1971 · S/N 28-7205013N72NEr Flight LLC · Reedsville, PABuilt 1971 · S/N 28-7205125N7300WTaylor Robert P · Bothell, WABuilt 1963 · S/N 28-1064N7301FMcpherson Alan · Big Bend Ntl Park, TXBuilt 1968 · S/N 28-25213N7301JJach Joshua Spenser · Grand Prairie, TXBuilt 1968 · S/N 28-24596N7303FAyrey Elias · Bellingham, WABuilt 1968 · S/N 28-25215N7303JButtleman Robert L · Traverse City, MIBuilt 1968 · S/N 28-24588N7304FReid Brian S · Merced, CAS/N 28-25216N7304JAdk Flying Club Inc · Ballston Spa, NYBuilt 1968 · S/N 28-24648N7305JMallozzi Anthony M · Norwalk, CTBuilt 1968 · S/N 28-24636N7306FMeans James · Burleson, TXS/N 28-25219N7307FEllis Johnathan · Evansville, WYS/N 28-25220N7307JAlmonte Duran Arquimedes · Paterson, NJBuilt 1968 · S/N 28-24640N7308CChandler Air Service Inc · Chandler, AZBuilt 1975 · S/N 28-7625075N7308JMacdermaid Harry R · Kenai, AKFirst renewal noticeBuilt 1968 · S/N 28-24616N730FNNguyen David · Cedar City, UTBuilt 1970 · S/N 28-26701N7311FRegistered aircraftBuilt 1968 · S/N 28-25225N7311JBouley John T · Tolland, CTFirst renewal noticeBuilt 1968 · S/N 28-24658N7314FAero Vantage Aviation Services LLC · Bayonne, NJBuilt 1968 · S/N 28-25272N7314WWelch Tully D · Brackettville, TXBuilt 1963 · S/N 28-1177N7315WPayne Victor · Brasstown, NCBuilt 1963 · S/N 28-1179N7316WCallaboo LLC · Greenwood, SCBuilt 1963 · S/N 28-1180N7317FMiller Steven G · Kent, WABuilt 1968 · S/N 28-25227N7317JBengtson Timothy R · Boulder Creek, CABuilt 1968 · S/N 28-24666N7318FTwo Weeks LLC · East Palo Alto, CABuilt 1968 · S/N 28-25228
Back to AD 96-10-01 R1