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.

N9939XGrant Matthew D · Alvord, TXS/N 1850139N9939ZRiver Front Akn LLC · Anchorage, AKBuilt 1983 · S/N U20606758N993CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1998 · S/N 17280317N993DWDeadstick Holdings LLC · Laguna Niguel, CABuilt 1963 · S/N 18255149N993GAUtopia Flyers LLC · Utopia, TXBuilt 1972 · S/N 18261152N993KTFirst Air Service LLC · Show Low, AZBuilt 1978 · S/N 18266450N993PDCertified Aviation LLC · Morristown, NJBuilt 1999 · S/N 172S8306N993PPCc Bar Ranch LLC · Texarkana, TXBuilt 1975 · S/N U20602634N9940ESaint Louis University · Saint Louis, MOBuilt 1975 · S/N 18264000N9940MSofinme LLC · Missoula, MTS/N U20604590N9940VSoco Aero Leasing LLC · Santa Rosa, CABuilt 1974 · S/N 17264566N9941BBrinkley Christian D · Minneapolis, MNBuilt 1957 · S/N 34341N9941MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1982 · S/N 20700748N9941VMorris Gray S · Chugiak, AKS/N 18051793N9941ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606760N9942MAlaska Aircraft Leasing LLC · Silverdale, WAFirst renewal noticeBuilt 1982 · S/N 20700756N9942QWarren John Russell · Los Alamos, NMBuilt 1975 · S/N 17265886N9943ASipple Ronald W Jr · Gardner, KSBuilt 1950 · S/N 19303N9943ELerud Peder E · Stockton, CABuilt 1979 · S/N 17272294N9943MBristol Bay Air Service Inc · Dillingham, AKBuilt 1982 · S/N 20700757N9943QGrove Todd M · Lake Stevens, WABuilt 1976 · S/N 17265887N9943VNewsom John · Lubbock, TXBuilt 1966 · S/N 18051797N9943XN63e LLC · Fallon, NVS/N 185-0143N9943ZState Of Maine Department Of Agriculture · Old Town, MEBuilt 1983 · S/N U20606762N99442Sale Reported · Kissimmee, FLSale reported, pending cancellationS/N 17276447N9944ESw Aviation LLC · Norman, OKBuilt 1975 · S/N 18264004N9944NJungclaus Karl F · Piedmont, SDBuilt 1975 · S/N 18052599N9944QSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265888N9944RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1986 · S/N U20606993N9944VHinkes Michael T · Fairbanks, AKBuilt 1966 · S/N 18051798N9944XChristian Dana J · Bozeman, MTBuilt 1961 · S/N 185-0144N9944ZChaparral Air Group · Grapevine, TXS/N U20606763N9945EWilcox John C · Aurora, NEBuilt 1979 · S/N 17272295N9945HCbw Holdings LLC · Columbia, TNBuilt 1981 · S/N 18268133N9945QClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 17265889N99465Farzam Hamid · Newington, CTBuilt 1985 · S/N 17276450N99467Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276451N9946BFuehrer John G II · Ephrata, PABuilt 1957 · S/N 34346N9946ELorenz Gary W · La Mesa, CABuilt 1975 · S/N 18264006N9946MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700588N9946QHorizon Aviation LLC · Sinclair, MEBuilt 1975 · S/N 17265890N9946TKruger Matthew J · Pine Island, MNBuilt 1960 · S/N 18253046N9946XBarber Edward G Jr · Anchorage, AKBuilt 1961 · S/N 185-0146N9947BClarke Adam M · Lompoc, CAS/N 34347N9947EAstle James H · St John, KSBuilt 1975 · S/N 18264007N9947GArthur Aviation LLC · Arthur, NDBuilt 1971 · S/N 18800747N9948AHoatson Larry · Yucaipa, CABuilt 1950 · S/N 19308N9948MGrant Aviation Inc · Anchorage, AKBuilt 1982 · S/N 20700759N9948TMoulton Robert J · Filer, IDBuilt 1960 · S/N 18253048N9948VSchultz Vaughn P · Marysville, CABuilt 1977 · S/N R1722356
Back to AD 79-10-14 R1