AD 71-06-06

Registered aircraft · 87

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:71-06-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:71-06-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.

N40352Shriner 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 2172CN40669Copp Perry T · Adin, CABuilt 1973 · S/N 2177CN40676Farrell Tammy Jean · Sterling, AKS/N 2180CN40677Merrell Jared · Wasilla, AKS/N 2181CN40807Hamilton Richard M Trustee · Willow, AKS/N 2076CN411CBOsky Deuce LLC · Saguache, COBuilt 1968 · S/N 2037CN4550RCarpenter Kevin C · Dallas, TXS/N 2017CN474WH&H Restoration LLC · Wasilla, AKS/N 2027CN51127Elsner Henry · Greensboro, NCBuilt 1973 · S/N 2188CN51207Crosswind Ventures LLC · Carson City, NVBuilt 1973 · S/N 2186CN56HBLopez Michael · North Pole, AKBuilt 1972 · S/N 2143CN615SDHolland Andrew K · Sterling, AKS/N 2083CN6JNRinaldi Stephen J · Plymouth, CTBuilt 1970 · S/N 2043CN86988Triple W Metal Building Construction LLC · Weatherford, TXBuilt 1973 · S/N 2137CN9237ZBugden Michael S · Newnan, GABuilt 1969 · S/N 2028CN92WVSilvey Lloyd R · Hale, MOBuilt 1970 · S/N 2040CN9865MLaing Thomas L · Aurora, COS/N 2003CN986RHebblewhite Arthur E · Waunakee, WIBuilt 1971 · S/N 2081CN9GMColman Scott Preston · Tampa, FLBuilt 1972 · S/N 2131C
Back to AD 71-06-06