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.

N6954XSebestik William C · Walker, MNS/N 17247854N6955AFortman James · Vancouver, WABuilt 1956 · S/N 29055N6955EGopalakrishna Prahlad Menon · Gibsonia, PABuilt 1959 · S/N 56455N6955GExecutive Aircraft International Inc · Bolivar, TNS/N 15072455N6955NSweet Fred A · Loves Park, ILBuilt 1981 · S/N 18504315N6955SHhd Aviation LLC · Hamilton, OHBuilt 1967 · S/N 15067655N6955VNeu Timothy F · Orlando, FLBuilt 1965 · S/N 18256630N6955XDirigo Aerospace Solutions LLC · Sumner, MEBuilt 1960 · S/N 17247855N6956AChristensen Curtis A · Lincoln, NEBuilt 1956 · S/N 29056N6956EMetzger Greg · Clovis, CABuilt 1959 · S/N 56456N6956GR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 15072456N6957FRussell Clyde R Jr DBA · Montrose, ARS/N 15063557N6958EAnderson Glenn Merrell · Duluth, MNBuilt 1959 · S/N 56458N6958GScoskie Keith E · Van, TXBuilt 1970 · S/N 15072458N6958HJewell Aviation Inc · Kennett, MOBuilt 1975 · S/N 17265663N6958SPeterson Leonard J · Cleveland, TNBuilt 1967 · S/N 15067658N695CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12156N695SPJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8623N6960FFirst Waypoint LLC · Mckinney, TXS/N 15063560N6960HZiller Wayne Jr · Fairbury, ILBuilt 1975 · S/N 17265664N6961ABontadellis Flying Service Ll · Polson, MTBuilt 1956 · S/N 29061N6961XHays Christopher Keith · Cleveland, MSS/N 17247861N6962ARogakis Christopher M · Spring Hill, KSBuilt 1956 · S/N 29062N6962FSiegrist Gary D · Belvidere, ILS/N 15063562N6962GGill Robert S · Anchorage, AKBuilt 1970 · S/N 15072462N6962MAbramson Jerrold B Trustee · Simi Valley, CABuilt 1975 · S/N 18263901N6962XBradsher Harold M · Troy, MOBuilt 1960 · S/N 17247862N6963AFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1956 · S/N 29063N6963MHathaway Virgil F · Spokane, WABuilt 1975 · S/N 18263902N6964AJackalope Aviation LLC · Bellingham, WAS/N 29064N6964HMor Aviation N6964h LLC · Gaithersburg, MDBuilt 1975 · S/N 17265668N6965FJefferies Vincent B · Rock Springs, WYBuilt 1966 · S/N 15063565N6965SSawyer Donald · Johnson, VTS/N 15067665N6966EVangundy Harold R · North Salem, INS/N 56466N6966GHotsenpiller Larry E · Sedalia, MOBuilt 1970 · S/N 15072466N6966SStout Larry E · Winamac, INBuilt 1967 · S/N 15067666N6967BChalk 2 Inc · Apple Valley, CABuilt 1978 · S/N 21062857N6967ELafrance Nathan Alexander · Arlington, TXBuilt 1959 · S/N 56467N6967GHuddleston Edward I · Oaktown, INS/N 15072467N6967NSand Creek Oil & Gas Inc · Edmond, OKBuilt 1979 · S/N 21063177N6968EGladden David G · Wasilla, AKBuilt 1959 · S/N 56468N6968STrue Robert S · Prosper, TXS/N 15067668N6968XTurner David M · Edgewood, WABuilt 1960 · S/N 17247868N6968ZMeili Charles E · Kingwood, TXBuilt 1965 · S/N 185-0968N6969FBrannan William C · Temecula, CAS/N 15063569N6969YTorres Charles O · Riverside, CABuilt 1966 · S/N T210-0150N696AGWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261326N696ALPas Aviation Inc · Modesto, CAS/N R1722047N696CBWhitmire Aviation LLC · Saint Augustine, FLS/N 177RG0333N696EAHubbard Broadcasting Inc · Saint Paul, MNBuilt 2005 · S/N 18281722
Back to AD 79-10-14 R1