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.

N70387Becker Flying Service Inc · Hartington, NEBuilt 1974 · S/N 18801905N7038EBrainerd Phillip S · Lake Placid, FLBuilt 1960 · S/N 56538N7038GRoeder Blaine W · El Prado, NMBuilt 1973 · S/N 15074609N7038QSchenone William M · Mattituck, NYBuilt 1971 · S/N 17260338N7038TNostdahl Robert W · Bottineau, NDBuilt 1961 · S/N 56331N7038XBrown Timothy J · Madison, SDBuilt 1960 · S/N 15059138N70391Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502144N70392Gateway Flying Club Inc · Blaine, MNBuilt 1976 · S/N 17267211N70394Halford Richard W · Eagle River, AKS/N 18502147N7039FWharam Glen A · Park River, NDBuilt 1966 · S/N 15063639N7039GWood Donna L · Wisconsin Dells, WIBuilt 1973 · S/N 15074610N7039MFurdal Lukasz · Hillsborough, NJBuilt 1958 · S/N 55339N7039SHotel Sierra LLC · Madison, WIBuilt 1976 · S/N 18265051N7039XOlson Scott G · New England, NDBuilt 1961 · S/N 15059139N703AGRegistration Pending · Moorcroft, WYRegistration pendingBuilt 1967 · S/N 337-0727N703BFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13488N703BKKenzy 2023 LLC · Castle Rock, COBuilt 2023 · S/N 172S12991N703CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281703N703LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11387N703MMGuidry Kirby J Jr · Blanco, TXBuilt 2000 · S/N 18280760N703SPFlightline LLC · Lewes, DEBuilt 1985 · S/N 172-76443N703VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1963 · S/N 17250823N703ZSibert Gerald R · Tacoma, WABuilt 1971 · S/N 18260582N70403Mccormick Eugene C DBA · Tyler, ALBuilt 1974 · S/N 18801912TN7040EPegasus Royalty Group LLC · Bozeman, MTBuilt 1960 · S/N 56540N7040FVtf LLC · Winter Haven, FLBuilt 1966 · S/N 15063640N7040MHood Shawn D · Weatherford, TXBuilt 1958 · S/N 55340N7040QOrlandi Properties LLC · Blairstown, NJBuilt 1971 · S/N 17260340N7040SPro Plus Holdings LLC · Gillette, WYBuilt 1976 · S/N 18265052N7040TLesko Shannon Lt · Loves Park, ILBuilt 1959 · S/N 46640N70411Charlie Lima 1 LLC · Jacksonville, FLBuilt 1976 · S/N 17267216N70413Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1976 · S/N 17267217N70416Mcgee David · West Monroe, LAS/N 17267218N7041AOfarrell Scott T · Seattle, WABuilt 1956 · S/N 29141N7041EDykstra Wayne A · Pipestone, MNS/N 56541N7041GJohnson Justin Eric · Grand Forks, NDBuilt 1969 · S/N 17258741N7041QElizabeth City State University · Elizabeth City, NCBuilt 1971 · S/N 17260341N7041SMaclean John A · Glenview, ILBuilt 1967 · S/N 15067741N7042AGuilbert Gerald L Jr · Fairfax, VABuilt 1956 · S/N 29142N7042EBennett Cass · Oxnard, CABuilt 1960 · S/N 56542N7042FKadlecovic Martin · Prescott, AZS/N 15063642N7042G7042g LLC · Shingle Springs, CAS/N 17258742N7042QWatts Ruiz LLC · Waco, TXBuilt 1971 · S/N 17260342N7042SNuernberger Howard P · State College, PABuilt 1967 · S/N 15067742N7042XSale Reported · Larwill, INSale reportedS/N 15059142N70438Sneller Heath E · Annandale, MNBuilt 1973 · S/N 18502170N7043ETri State Airmotive LLC · Berryville, ARS/N 56543N7043QNelson Christopher J · Hayfield, MNBuilt 1971 · S/N 17260343N7043SBaughman Jeffrey S · Keller, TXBuilt 1967 · S/N 15067743N7043XMile High Flight Club Inc · Miami, FLBuilt 1961 · S/N 15059143
Back to AD 79-10-14 R1