OpenAirDocs.org
AD 74-13-06

Registered aircraft · 2,242

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:74-13-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-13-06')
  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.

N1005FBeam Douglas J Trustee · Chugiak, AKBuilt 1975 · S/N 18502677N100GKLewis David B · Saint Louis, MOBuilt 1973 · S/N 210-59905N100YNEnrique Angulo · San Diego, CAS/N 21061236N1015FInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18502684N101JHHi-Per Aviation Inc · Arroyo Grande, CABuilt 1972 · S/N 21059759N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404N1022FGoodfellow Malcolm D · Seattle, WABuilt 1975 · S/N 18502690N1023FWinter Karl · Litchfield Park, AZBuilt 1975 · S/N 18502691N10242Alexander Holding Services Inc · Newark, DEBuilt 1972 · S/N 21059704N1028FLunoe Leif C · Anchorage, AKBuilt 1975 · S/N 18502695N1031VIntelinair Geospatial LLC · Indianapolis, INBuilt 1974 · S/N U20602409N103AMN103am LLC · Chehalis, WABuilt 1974 · S/N 18502615N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484N1043FBakkes Francois · Sitka, AKBuilt 1975 · S/N 18502700N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418N1047FBondurant Jok · Talkeetna, AKS/N 18502704N104BWJurak Mike D · Kimberly, IDBuilt 1974 · S/N 18502517N104DEVince John G · West Ossipee, NHBuilt 1980 · S/N 18504009N104HEDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1975 · S/N 18502742N104TRAuburn Sheet Metal Inc · Enumclaw, WABuilt 1976 · S/N 18503212N1050FBuchan John F · Port Ludlow, WABuilt 1975 · S/N 18502707N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421N1052FGlb Farms Inc · Pasco, WABuilt 1975 · S/N 18502709N1056FBrasil John I · Lemon Grove, CABuilt 1975 · S/N 18502712N105NBNorthcentral Aircraft LLC · Blaine, MNBuilt 1984 · S/N 18503732N1060FStrausbaugh Paul L · Clifton Forge, VABuilt 1975 · S/N 18502716N1062FSale Reported · Independence, ORSale reportedBuilt 1975 · S/N 18502718N1065VRegistered aircraftBuilt 1974 · S/N U20602435N1074FNorth River Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502730N1076FCavu Clearing LLC · Center Harbor, NHS/N 18502732N1077ABabcock Mark E · Auburn, WABuilt 1977 · S/N 18503156N1077FScileppi Gregory S · Sea Island, GABuilt 1975 · S/N 18502733N1078FWilliams Casey D · Wasilla, AKBuilt 1975 · S/N 18502734N107JPPayne Thomas E · Old Forge, NYBuilt 1973 · S/N U20602079N107LHale Mitchell D · Chugiak, AKBuilt 1978 · S/N 18503535N107TYThornock Ty D · Shawano, WIS/N 18502836N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453N1084FSiktberg Timothy J · Nashville, TNBuilt 1975 · S/N 18502739N1089FWells Thomas J · Big Lake, AKBuilt 1975 · S/N 18502744N1095FEggart Lawrence D · Nome, AKS/N 18502750N1099FSaal Christopher J · Anchorage, AKBuilt 1975 · S/N 18502754N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616N10HGGerardy Harlan D · Gruver, TXBuilt 1974 · S/N 21060169N10HLHoyt Robert H Trustee · Canby, ORBuilt 1975 · S/N 21060646N10JVHale Thomas O · Cotuit, MABuilt 1973 · S/N 18502242N10RP4f Aviation LLC · Palmer Lake, COBuilt 1972 · S/N 21059779N10SBSackett Michael · Nordman, IDBuilt 1975 · S/N 21060920N10YSeitz William D · Gordonville, TXBuilt 1972 · S/N 21059697N10YTN10yt LLC · Missoula, MTBuilt 1976 · S/N 21061460
Back to AD 74-13-06