AD 2016-14-05

Registered aircraft · 781

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

N34CLBarrett Benjamin C · Gorham, MEBuilt 1958 · S/N 55363N377RMDinucci Gino · Clearwater, FLBuilt 1960 · S/N 56713N40184Stoots David A · Fairbanks, AKBuilt 1958 · S/N 55245N406BNClover Crest II Inc · Key Largo, FLBuilt 1959 · S/N 56122N416DCWeaver Eric W · Anchorage, AKBuilt 1959 · S/N 55940N444REJenson Greg Ray · Pueblo, COS/N 55174N4450CC & C Auto Sales LLC · Atlanta, MOBuilt 1960 · S/N 56553N470HDChandler Dennis · Castroville, TXBuilt 1958 · S/N 55288N470JBLong James · Lyman, WYS/N 55041N47KVCaron Robert M · Vero Beach, FLBuilt 1959 · S/N 56239N5089Gifford David M · Las Vegas, NVS/N 56756N522JHMinor Steve A · Twain Harte, CAS/N 55902N525ZMMaba Aircraft Services Co · Vero Beach, FLS/N 56760N531VMcmillan Mark Gilbert · Oak Harbor, WABuilt 1960 · S/N 56685N540DHoopes Kristopher · Davis, OKBuilt 1959 · S/N 55907N54973Szymanski Tadeusz C · Fort Myers, FLS/N 55217N58FAAlman Michael C · Fruitport, MIBuilt 1958 · S/N 55255N59175Brown Charles A · Boise, IDBuilt 1959 · S/N 55932N59YYBay Richard P · West Jordan, UTBuilt 1960 · S/N 56429N5HVOppegard Nicholas D · Eagle River, AKBuilt 1958 · S/N 55366N649ARSmith Roy Dennis · Buckeye, AZBuilt 1959 · S/N 55953N6501ERobinson James W · Henderson, NVBuilt 1959 · S/N 56001N6505EHeman Darrick L · Blue Springs, MOBuilt 1959 · S/N 56005N6506EArmstrong Bruce · Port Orchard, WABuilt 1959 · S/N 56006N6510EScherer Luis R · Kent, OHBuilt 1959 · S/N 56010N6511EMckenna Francis · Granville, PABuilt 1959 · S/N 56011N6517ERed Baron LLC · Middletown, DES/N 56017N6518EMozingo James C · Hernando, FLBuilt 1959 · S/N 56018N6520ENichols Matthew Q · Maple Valley, WABuilt 1959 · S/N 56020N6521EWeaver Clifford A · East Berlin, PABuilt 1959 · S/N 56021N6523ESkeen Andrew · Lindon, UTBuilt 1959 · S/N 56023N6524EWhite Wings LLC · Anchorage, AKBuilt 1959 · S/N 56024N6527ETaylor Carey A · Rainier, WABuilt 1959 · S/N 56027N6532ERegistration Pending · Maize, KSRegistration pendingS/N 56032N6537EDittmer Michael C · Springtown, TXS/N 56037N6540EAerial Crop Care Co · Hebron, NDBuilt 1959 · S/N 56040N6541EAkers Sean M · East Wenatchee, WAS/N 56041N6542EBond Ward Thomas · Salem, MOBuilt 1959 · S/N 56042N6544ESando Jan R · St Louis Park, MNS/N 56044N6546EMenard Keith L · Bellevue, TXS/N 56046N6549ENewton Donald H · Lewistown, MTBuilt 1959 · S/N 56049N6551EMoore Henry J · Deer Park, WABuilt 1959 · S/N 56051N6557EClor Rosalee G · Saint Clair, MIS/N 56057N6559ECarlson Garrett R · Ramsey, MNS/N 56059N6560EAeschliman Arlie W · Tribune, KSBuilt 1959 · S/N 56060N6563EWorld Aircraft Inc · San Antonio, TXBuilt 1959 · S/N 56063N6564EAtcheson John R · Franklin, GAS/N 56064N6565EGeyer Brian E · Souderton, PAS/N 56065N6567EHastings Larry K · Lubbock, TXBuilt 1959 · S/N 56067N6571ELersner Bradley D · Katy, TXBuilt 1959 · S/N 56071
Back to AD 2016-14-05