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.

N6638WTugmon Danny · Locust Grove, OKBuilt 1965 · S/N 28-20737N6639JColoski Dennis J · Marlton, NJBuilt 1968 · S/N 28-5106N6640JHeesch Donald · Nunn, COS/N 28-5107N6640WAldrich David G · Naples, FLBuilt 1965 · S/N 28-20739N6641JStratus Business Development LLC · Nashua, NHBuilt 1968 · S/N 28-5109N6642JFive By Ten LLC · Loveland, COBuilt 1968 · S/N 28-5110N6642WBrown Kevin D · Saint Louis, MOBuilt 1965 · S/N 28-20742N6643JJohnson Steve · Attleboro, MABuilt 1968 · S/N 28-5111N6643WWeiss Stephan T · San Jose, CABuilt 1965 · S/N 28-20743N6645JMcdonald Neill F Jr · Fairfax, VABuilt 1968 · S/N 28-5131N6645WHolman Robert S · Delta, UTBuilt 1965 · S/N 28-20745N6646JNoize Farm Inc · Cheyenne, WYBuilt 1968 · S/N 28-5133N6646WCordova Jesse · Raymore, MOS/N 28-20746N6647WPanama Truck Line LLC · Florissant, MOBuilt 1965 · S/N 28-20748N6649JBowline Ray D · Salina, OKBuilt 1968 · S/N 28-5064N664FLElon Aviation LLC · Burlington, NCBuilt 1971 · S/N 28-7125586N6650JCarolian Aviation LLC · Bexley, OHBuilt 1968 · S/N 28-5076N6650WCole Alexander G · Leander, TXBuilt 1965 · S/N 28-20751N6651WPeeples Timothy W · Griffin, GAS/N 28-21277N6652FCrosswind Aviation Inc · Oakley, KSS/N 28-7725076N6652WLumley John J · Delray Beach, FLBuilt 1965 · S/N 28-20754N6654WKosko Stanley G · Seattle, WABuilt 1965 · S/N 28-21279N6655JLaukkanen Heikki J · Camas, WABuilt 1968 · S/N 28-5139N6655W5b Aviation LLC · Duncan, OKS/N 28-20757N6656JFauber Clifford W · Cincinnati, OHBuilt 1968 · S/N 28-5141N6657JRegistration Pending · Tavares, FLRegistration pendingS/N 28-5142N6657WKlienstuber James D · Yamhill, ORBuilt 1965 · S/N 28-20760N6659JDuffey Albert J · Clover, VABuilt 1968 · S/N 28-5146N6659WJeffrey Franklin B · Suisun City, CABuilt 1965 · S/N 28-20762N665DPPflum David R · Roscommon, MIBuilt 1970 · S/N 28-5817N6661WGoing To Rome LLC · Valley Center, KSS/N 28-20764N6664WN6664w LLC · Grand Prairie, TXBuilt 1965 · S/N 28-21281N6666JGhormley James G · Arlington, TXBuilt 1968 · S/N 28-24352N6666WReed Phillip G · Troy, TNBuilt 1965 · S/N 28-20770N6669WSeiler Brent L · Burton, TXBuilt 1965 · S/N 28-20774N666FLWoodhouse Ashley T · Sylmar, CABuilt 1971 · S/N 28-7125589N6670WHighland Asset Management · Auburn, CABuilt 1965 · S/N 28-20775N6671JRotor And Wing LLC · Tioga, NDBuilt 1968 · S/N 28-24357N6671WSessions Max R · Moody, ALS/N 28-21282N6673JMoody Edward L Jr · Candler, NCBuilt 1968 · S/N 28-24359N6673WCk Nickels Inc · Muleshoe, TXBuilt 1965 · S/N 28-20780N6675JReece Aviation LLC · North Clarendon, VTBuilt 1968 · S/N 28-24362N6676JRozof Chester F · Fort Myers, FLBuilt 1968 · S/N 28-24363N6676WWorkman Industries Inc · Durant, IABuilt 1965 · S/N 28-20783N6677WOsgood Darrell F · Watervliet, MIBuilt 1965 · S/N 28-20784N6678JWiener Ronald K · Tucson, AZBuilt 1968 · S/N 28-24365N6678WMadison Andrew J · Inver Grove, MNS/N 28-20786N6680JElliott Bryn · Blue Point, NYS/N 28-24368N6684WWaltman Richard Dean · Moses Lake, WAFirst renewal noticeBuilt 1965 · S/N 28-20790N6685WZulueta David · Louisville, GAS/N 28-20791
Back to AD 96-10-01 R1