AD 79-10-14 R1

Registered aircraft · 56,582

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:79-10-14-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:79-10-14-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.

N7607FRolinski Alexander S · Deland, FLBuilt 1979 · S/N 17273265N7607GOwens Wilbur · Rch Palos Vrd, CAS/N 17259307N7607SBelle Valle Aviation LLC · St Petersburg, FLBuilt 1978 · S/N 18265255N7607TVantine Willard W III · Lexington, SCBuilt 1959 · S/N 47207N7607XHall Douglas F · Pembine, WIBuilt 1960 · S/N 17248107N7608FAj Mush LLC · Dearborn, MIBuilt 1979 · S/N 17273266N7608MInspiration Aviation LLC · Mesa, AZBuilt 1959 · S/N 55908N7608SMkc Flying LLC · Gladstone, MOBuilt 1976 · S/N 18265256N7608XStanton Todd D · Plains, KSBuilt 1960 · S/N 17248108N76091Riverside Flight Academy Inc · Riverside, CAS/N 17268121N7609FKomberec Eric R · Kalispell, MTBuilt 1979 · S/N 17273267N7609MYoung Robert D · Georgetown, DEBuilt 1959 · S/N 55909N7609QPierson Janice R Trustee · Scio, ORBuilt 1978 · S/N 18503626N7609SButzbaugh Elden W Jr · Saint Joseph, MIBuilt 1976 · S/N 18265257N7609THall Donald P · Anacortes, WABuilt 1959 · S/N 47209N760BWBridgewater State University · Bridgewater, MABuilt 1999 · S/N 17280775N760CAMcculloch Matthew L · Stoutland, MOBuilt 1975 · S/N 15076356N760CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13056N760JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13597N760LADna Flight LLC · Hillsboro, ORBuilt 2023 · S/N 172S13083N7610CSawtooth Flying Service Inc · Mccall, IDBuilt 1977 · S/N U20603924N7610GFalconer Robert H · Yolo, CABuilt 1970 · S/N 17259310N7610MEickhoff Steven M · Fountain, MNBuilt 1977 · S/N 21062030N7610TDines Stephen R · Monument, COBuilt 1965 · S/N 47210N7611FGeneral Aviation Support Corp · Rosamond, CAS/N 17273269N7611GStaunton Curtis J · Tulelake, CABuilt 1970 · S/N 17259311N7611SMile High Advertising Inc · Doylestown, PABuilt 1976 · S/N 18265259N7612GSwartwood Thomas C · Everson, WABuilt 1970 · S/N 17259312N7612KDeblack Richard B · Crosslake, MNBuilt 1976 · S/N 18052689N7612MHall Adam Patrick · Borrego Springs, CABuilt 1959 · S/N 55912N7612TBabcock Douglas O · Chesterton, INBuilt 1960 · S/N 47212N7614VTucker Aviation LLC · Kalispell, MTBuilt 1976 · S/N 177RG0891N7615AUpton Michael James · Anchorage, AKBuilt 1956 · S/N 32512N7615GWashington Samuel C · Washington, DCS/N 17259315N7615NHelms Aviation Inc · Long Lake, NYBuilt 1977 · S/N U20603706N7615TN Maple LLC · Kalispell, MTS/N 47215N7615XEagle Flight Inc. · Fremont, NEBuilt 1960 · S/N 17248115N7616KHarrison William Thomas · West Richland, WAFirst renewal noticeS/N 18052690N7616MGriffin Robert L Jr · Washington, NCBuilt 1959 · S/N 55916N7616NFox Tim · Obion, TNBuilt 1974 · S/N 18263274N7616UShepard Gregory W · Fort Myers, FLBuilt 1975 · S/N 15077770N76172Rjd Flight LLC · North Canton, OHBuilt 1975 · S/N 17265906N76177Brown Emily D · Niceville, FLBuilt 1975 · S/N 177RG0817N7617URikki Air LLC · Clarksville, TXBuilt 1975 · S/N 15077771N76182Vaughan Steven T · Overland Park, KSBuilt 1976 · S/N 18264888N76185Snell Marion Lea · Ackerly, TXS/N 18503013N7619GMercer Aviators Inc · Princeton, WVBuilt 1970 · S/N 17259319N7619NAir Alday LLC · Pompano Beach, FLBuilt 1974 · S/N 18263277N7619XWeitzel Claus P · Newington, GABuilt 1960 · S/N 17248119N761AFranz Construction Inc · Sidney, MTS/N 18504424
Back to AD 79-10-14 R1