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.

N50434Summerville Daniel · Millersville, MDBuilt 1968 · S/N 15069301N50438Roche Thomas A · Bardstown, KYBuilt 1968 · S/N 15069303N5043AStephens Zachary L · Big Lake, AKS/N 28043N5043JValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 172S10861N5043RRegistered aircraftBuilt 1974 · S/N 17263284N5044APatzanakidis Konstandinos · Jupiter, FLBuilt 1955 · S/N 28044N5044DCarpenter Corey · Warden, WAS/N 51144N5044EAviation Needs LLC · Stapleton, NEBuilt 1978 · S/N 17271698N5044HCoogan Dennis P · Madison, WIBuilt 1975 · S/N 17265315N5044RSouth Bay Flight Training Center · Carolina, PRBuilt 1974 · S/N 17263285N50457Odyssey Entertainment Inc · Crystal, MNBuilt 1977 · S/N 177RG1133N5045HGrabofsky Livestock & Grain Inc · Hogeland, MTBuilt 1975 · S/N 17265316N50462Weekley Clint · Manvel, TXBuilt 1974 · S/N 17264202N50465Howard Wayne A · Loon Lake, WABuilt 1968 · S/N 15069322N50467Hastings Stephen J · Palmer, AKBuilt 1968 · S/N 15069324N5046AHappy Landings Aviation LLC · Maple, NCBuilt 1955 · S/N 28046N5046RSandpoint Aviation LLC · Sandpoint, IDS/N 18502988N50471Honsperger Karl J Trustee · Fremont, OHBuilt 1968 · S/N 15069327N50473Cobrinik Adam · Whites Creek, TNBuilt 1968 · S/N 15069329N50474Mother Lode Flying Club · San Andreas, CABuilt 1968 · S/N 15069330N50475Mc Ironworks Welding And Fabrication Inc · Chico, CABuilt 1968 · S/N 15069331N50479Alvarez Randolph Clarence · Igiugig, AKBuilt 1974 · S/N 17264204N5047AAeroslat4 LLC · Lewes, DEBuilt 1955 · S/N 28047N5047DMarler Don T · Pocatello, IDBuilt 1958 · S/N 51147N50484Freudenthal Jack J · Medford, WIBuilt 1974 · S/N 17264205N50485Wiedeman Douglas J · Springboro, OHBuilt 1974 · S/N 17264206N50488Fratti Robert B · Nampa, IDBuilt 1968 · S/N 15069340N5048RSandeep Sharma LLC · Oshkosh, WIBuilt 1974 · S/N 17263289N5048VLoewen Wielhelm · Presidio, TXBuilt 1977 · S/N R1722274N50497Meurer Carl J · Little Rock, ARBuilt 1968 · S/N 15069347N5049RIndiana Paging Network Inc · La Porte, INBuilt 1974 · S/N 17263290N504EAOlympic Jet Inc · Olympia, WABuilt 2000 · S/N 20608133N504FAClow International Airport LLC · Bolingbrook, ILBuilt 2003 · S/N 172S9504N504JRitter Michael W · Cumberland, MDBuilt 1974 · S/N 15076142N504JCFrequent Flyer LLC · Manasquan, NJBuilt 1973 · S/N 18502155N504JJEdwards William A · Midland, GABuilt 1979 · S/N 17273419N504JWPalmer Gary H · San Juan, TXBuilt 1981 · S/N 21064232N504MAEastern Kentucky University · Richmond, KYBuilt 1983 · S/N 17275917N504QChelatna Lake Lodge LLC · Anchorage, AKS/N U2061293N504SDPate Charles C Trustee · Wichita, KSBuilt 1961 · S/N 18253203N50502Behnke Randall · Manitowoc, WIS/N 15069351N50503Kelly Keith Austin · Oklahoma City, OKBuilt 1968 · S/N 15069352N50504Baker Merlin K · Bradford, OHBuilt 2001 · S/N 18281057N5050ACampbell Barry A · Rogersville, TNBuilt 1955 · S/N 28050N5051DVincent Wendal J · Geismar, LABuilt 1958 · S/N 51151N5051RSkywarrior Flight Training LLC · Pensacola, FLBuilt 1974 · S/N 17263291N50523Koch Allen William · Anchorage, AKBuilt 1974 · S/N 17264209N5052DFertic Knute · Oklahoma City, OKBuilt 1958 · S/N 51152N50530Kelly John M · Gastonia, NCBuilt 1968 · S/N 15069376N50531Davies Patrick R · Trussville, ALBuilt 1968 · S/N 15069377
Back to AD 79-10-14 R1