AD 68-07-08

Registered aircraft · 196

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

N3917CGortemiller Trevor Allen · Atkins, ARBuilt 1971 · S/N 2067-CN3MLTherp Todd J · Rigby, IDBuilt 1970 · S/N 2048CN40304Howard Nathan L · Fairbanks, AKFirst renewal noticeBuilt 1971 · S/N 2078CN40309Laurain Terry · Monroe, MIBuilt 1971 · S/N 2085CN40312Banks Mark Vernon · Jamestown, CABuilt 1971 · S/N 2086CN40314Husbands Jason · Belen, NMBuilt 1971 · S/N 2090CN40319Mceewen David L · Galata, MTBuilt 1972 · S/N 2094CN40324Weir John · High Point, NCS/N 2099CN40326Registration Pending · Bowdoin, MERegistration pendingBuilt 1972 · S/N 2101CN40329Goering Ryan I · Prineville, ORS/N 2104CN40330Hubbell Jef C · Kermit, TXBuilt 1972 · S/N 2105CN40331Snow Joe W · Pauls Valley, OKBuilt 1972 · S/N 2106CN40333Cathriner Robert A · Frisco, TXBuilt 1972 · S/N 2108CN40335Davis Philip L · Spring Hill, TNBuilt 1972 · S/N 2110CN40341Beer Carter · Columbus, MTBuilt 1972 · S/N 2117CN40342Rockwell Tracey W · Atlanta, INBuilt 1972 · S/N 2118CN40344Howard Nathan L · Fairbanks, AKFirst renewal noticeBuilt 1972 · S/N 2120CN40348Mattson Paul · San Diego, CABuilt 1972 · S/N 2125CN40352Shriner Justin M · North Pole, AKS/N 2130CN40354Wright Leva M · Somerville, ALBuilt 1972 · S/N 2132CN40606Huberd Jason K · Hereford, AZS/N 2135CN40614Marcotte Stuart E · Soldotna, AKBuilt 1972 · S/N 2138CN40617Morelli John Anthony · Grapevine, TXS/N 2140CN40619Merrell Jared · Wasilla, AKS/N 2141CN40628Herrington John · Marion, MTBuilt 1972 · S/N 2149CN40629Tejas Flying Services LLC · Ganado, TXBuilt 1972 · S/N 2150CN40633Rice Richard L · Rossville, TNBuilt 1972 · S/N 2151CN40634Nichols Michael H · Thompson Falls, MTFirst renewal noticeBuilt 1972 · S/N 2152CN40635Yuan Andrew W · Salinas, CABuilt 1972 · S/N 2153CN40640Koch Christopher P · Batavia, NYS/N 2158CN40645Ulrich Maggie Beth · Damascus, VABuilt 1972 · S/N 2161CN40646Holtzen Larry E · Jerome, IDBuilt 1972 · S/N 2162CN40647Rozum Richard A · Aguila, AZBuilt 1973 · S/N 2163CN40650Palmer Paul W · Joliet, ILBuilt 1973 · S/N 2166CN40653Registration Pending · Pea Ridge, ARRegistration pendingBuilt 1973 · S/N 2167CN40656Fairly Dustin L · Fairbury, NES/N 2170CN40657Frickel Thomas L · Bristow, NEBuilt 1973 · S/N 2172CN40661Barkay Ido M · Anchorage, AKBuilt 1973 · S/N 2173CN40667Nelson Bradley C · Williston, NDBuilt 1973 · S/N 1081CN40669Copp Perry T · Adin, CABuilt 1973 · S/N 2177CN40674Miller Sean C · New Carlisle, OHBuilt 1973 · S/N 2179CN40676Farrell Tammy Jean · Sterling, AKS/N 2180CN40677Merrell Jared · Wasilla, AKS/N 2181CN40684Johnson Jeff · Wasilla, AKBuilt 1973 · S/N 1083CN40686Bentley Aviation Services LLC · Lewes, DEBuilt 1973 · S/N 1084CN40689Combs Christopher G · Durham, CABuilt 1973 · S/N 1085CN40692Rocky Mountain Distributing LLC · Buffalo, MTS/N 1088CN40694Yeager And Co Inc · Boulder, COFirst renewal noticeBuilt 1973 · S/N 2184CN40807Hamilton Richard M Trustee · Willow, AKS/N 2076CN4089CBork Joseph L · Mosier, ORS/N 15
Back to AD 68-07-08