AD 96-10-01 R1

Registered aircraft · 8,138

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.

N1463TN1463t LLC · Oak Hill, VABuilt 1972 · S/N 28-7225529N1464TSiedentopf Zyurelaie Indiana · Yelm, WABuilt 1972 · S/N 28-7205302N1467TThree2tango LLC · Mount Pleasant, SCBuilt 1972 · S/N 28-7205305N1471TFranks James Charles · Conroe, TXBuilt 1972 · S/N 28-7225528N1471XSale Reported · Epworth, GASale reportedBuilt 1975 · S/N 28-7525311N1476TBough Jayce K · El Dorado Hills, CAS/N 28-7225530N1476XAbel Adam T · Aberdeen, OHS/N 28-7525309N1477TSrh Club Inc · Wilmington, DEBuilt 1972 · S/N 28-7205306N1477XRed Rock Flying School LLC · Mesa, AZBuilt 1975 · S/N 28-7525313N1478XMello Edward R Jr · Land O Lakes, FLBuilt 1975 · S/N 28-7525292N1484TPolasik Julia Suzanne · Victor, IDBuilt 1972 · S/N 28-7225531N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307N1491TGreat Lakes Air Ventures LLC · Mason, MIBuilt 1972 · S/N 28-7205308N1499HMeloney Leeyoung Chase · Peachtree City, GAS/N 28-7725146N149DCDale Gared W · Hugo, OKS/N 28-2643N14DP5b Aviation LLC · Duncan, OKBuilt 1970 · S/N 28-5738N14LNSchultz Tim J · Mount Juliet, TNBuilt 1971 · S/N 28-7225043N14NRPiper Capital Investments LLC · Denton, TXBuilt 1965 · S/N 28-20614N15002Registered aircraftBuilt 1972 · S/N 28-7205315N15003Flying Untethered LLC · Saranac Lake, NYBuilt 1972 · S/N 28-7225548N15005Oliver Everett G · No Mankato, MNBuilt 1972 · S/N 28-7205316N15010Van Buskirk James R · Tuttle, OKS/N 28-7225550N1501XBowser William K · Ball Ground, GABuilt 1975 · S/N 28-7505235N15032Ross Adam D · Bixby, OKBuilt 1972 · S/N 28-7225555N15033Fca Flight Training LLC · Washington C H, OHBuilt 1972 · S/N 28-7225556N15034Pathfinder Aviation Services LLC · St Johns, FLBuilt 1972 · S/N 28-7225557N15037Ace Aircraft Leasing Inc · Nazareth, PABuilt 1972 · S/N 28-7225560N1503XGasoline Valley LLC · Clyde, MIS/N 28-7525324N15044Summit Flight Academy LLC · Peculiar, MOBuilt 1972 · S/N 28-7225564N15046Neboschick Ashley B · North Charleston, SCBuilt 1972 · S/N 28-7325002N1504JRuminski Pamela S · Salesville, OHBuilt 1967 · S/N 28-23897N1504TChavez David L · Cedar Park, TXBuilt 1972 · S/N 28-7225500N15050Houston William W · Baltimore, MDBuilt 1972 · S/N 28-7225569N15051Phoenix Proaviation LLC · Jacksonville, FLS/N 28-7225570N15057Bad Dog Aviation · Meridianville, ALBuilt 1972 · S/N 28-7225572N15066Cherokee Aviation Group LLC · Alpharetta, GABuilt 1972 · S/N 28-7225577N1506HRegistration Pending · Cape Canaveral, FLRegistration pendingS/N 28-7725147N1506TWaldrep Zoey V · Tampa, FLS/N 28-7225538N15079Rea Robert III · Bumpass, VABuilt 1972 · S/N 28-7225585N1507TAero Care Inc · Orange, MABuilt 1972 · S/N 28-7205310N1508JLiwag Reynaldo T Jr · Niagara Falls, NYBuilt 1967 · S/N 28-23901N150PKInternational Air Services Inc Trustee · Carson City, NVS/N 287725108N15100Brothers Aviation Va LLC · Manassas, VABuilt 1972 · S/N 28-7225588N15101Blackwater Air LLC · Pace, FLBuilt 1972 · S/N 28-7305020N15104Mil2atp Inc · Pikeville, NCBuilt 1972 · S/N 28-7225590N15105Sass Phillip A · Leavenworth, KSBuilt 1972 · S/N 28-7225591N15106Chew Terrence G · Allyn, WABuilt 1972 · S/N 28-7305021N15107Skahen Sean M · Saint Joseph, MNS/N 28-7305022
Back to AD 96-10-01 R1