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.

N5038TBennett Howard N · Georgetown, KYBuilt 1972 · S/N 28-7225326N5038WMarx Karl E · Juneau, AKBuilt 1961 · S/N 28-40N5039TMitchell Robert D · Freehold, NYBuilt 1972 · S/N 28-7225328N5040TGamblin Ryan · Perry, GABuilt 1972 · S/N 28-7205241N5043WRushton Harold E · Nashville, TNBuilt 1961 · S/N 28-45N5044MMojocreatives Inc · Avondale Estates, GABuilt 1965 · S/N 28-20756N5045TTruex Theodore L · Peachtree City, GABuilt 1972 · S/N 28-7225332N5046TStp Flight LLC · Saint Paul, MNBuilt 1972 · S/N 28-7225333N5047WCooper James · Indianapolis, INBuilt 1961 · S/N 28-49N504FLMustafa Abdelrahman · Euless, TXBuilt 1971 · S/N 28-7125324N5050WLadeira Victor E · Holy Cross, AKBuilt 1961 · S/N 28-61N5052TMatos Jonathan A · Kent, WABuilt 1972 · S/N 28-7225334N5053TSchneckenburger Kurt Partrick · Bethesda, MDBuilt 1972 · S/N 28-7205243N5053WJonason David · Ocean Park, WABuilt 1961 · S/N 28-62N5057TGiber Michael S · New Port Richey, FLBuilt 1972 · S/N 28-7225338N5058TRebel Aviation Inc · Liberty, MOBuilt 1972 · S/N 28-7225339N5059TGimenez Roberto Jorge · Merritt Island, FLS/N 28-7205244N505FLComer Christopher C · Randleman, NCBuilt 1971 · S/N 28-7125325N5063TKramer Ryan T · Hector, MNBuilt 1972 · S/N 28-7225341N5065WAddai Emmanuel · Cincinnati, OHBuilt 1961 · S/N 28-74N5069WNelson Stephen A · Milaca, MNBuilt 1961 · S/N 28-78N5071LHill Karl D · Igiugig, AKBuilt 1967 · S/N 28-4456N5071WWallace Madison F · Thomasville, NCBuilt 1961 · S/N 28-80N5072WHurst Randall S · Altus, ARBuilt 1961 · S/N 28-81N5074WWells Byron R · Bunn, NCS/N 28-83N5077WSkyport Aviation LLC · Birmingham, IAS/N 28-86N507FLSpence Ryan · Chicopee, MABuilt 1971 · S/N 28-7125328N5080WMatzke Kevin T · Gilbert, AZBuilt 1961 · S/N 28-89N5084WShouse Robert G · Owasso, OKBuilt 1961 · S/N 28-93N5085WMartin Marlin Ray Jr · Mabank, TXBuilt 1961 · S/N 28-94N508THFowler David P · Freeport, MEBuilt 1967 · S/N 28-22869N5090WJaybird Aviation LLC · San Antonio, TXBuilt 1961 · S/N 28-99N5091WRegistration Pending · Anchorage, AKRegistration pendingBuilt 1961 · S/N 28-100N5093SPerez Matthew C · Indianapolis, INS/N 28-7125301N5096TRichards Lyle D · Riley, KSBuilt 1972 · S/N 28-7225344N5099TClark Darril W · Scappoose, ORBuilt 1972 · S/N 28-7225347N50YRBrowning James M · Milaca, MNBuilt 1969 · S/N 28-25467N5100LWilder Carl T · Budd Lake, NJBuilt 1967 · S/N 28-4372N5100SParks Victor Lee · Houston, TXBuilt 1971 · S/N 28-7125318N5101GWash Stephen · Franklin, TNBuilt 1967 · S/N 28-3969N5102GHeussler Ryan · Rio Dell, CABuilt 1967 · S/N 28-4003N5102SK & N Aviation LLC · Rock Hill, SCBuilt 1971 · S/N 28-7105125N5103GMcfarland Les · Bourbon, INBuilt 1967 · S/N 28-4004N5104LLamer Roland W · Fresno, CABuilt 1967 · S/N 28-4374N5105SSyphers Harold A · Aguila, AZBuilt 1971 · S/N 28-7125335N5106LArnold John D · Reno, NVBuilt 1967 · S/N 28-4376N5107LSmith Jeremy · Houston, TXBuilt 1967 · S/N 28-4389N5109GSnamiska Kyle · Cypress, TXBuilt 1967 · S/N 28-23174N5109SBucek James A · Baytown, TXBuilt 1971 · S/N 28-7105129N5110GN5110g LLC · Orlando, FLS/N 28-23211
Back to AD 96-10-01 R1