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.

N4923UUnited Indian Missions Inc DBA · Tucson, AZS/N U20605164N4924AMachnik Todd J · Old Lyme, CTBuilt 1956 · S/N 32321N4924DRobinson Anthony D · Brookshire, TXBuilt 1958 · S/N 51024N4924ENorthstar E & C LLC · Anchorage, AKBuilt 1979 · S/N 18503909N4924UScheren Raymond D · Johnson, VTBuilt 1965 · S/N 21058624N4925CRichardson Richard E II · Windham, MEBuilt 1975 · S/N 18502660N4925FA S Air LLC · Lantana, FLBuilt 1979 · S/N 17273103N4925GSchwenker David W · Queensbury, NYBuilt 1979 · S/N 17273472N4925QEsty Effew LLC · Wimberley, TXBuilt 2012 · S/N 18282326N4926AEngland John James · Montrose, COBuilt 1956 · S/N 32323N4927DGreenville Flight LLC · Greer, SCS/N 17272401N4927NRmst LLC · Mason, OHBuilt 1979 · S/N 18267457N4927QWakefield Aircraft LLC · Cooperstown, NDBuilt 1976 · S/N 18802662TN4927UBetz Brett A · Reminderville, OHBuilt 1965 · S/N 21058627N4928EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271676N4929AApling Randall L · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 32326N4929DUnion Flyers LLC · Union, SCBuilt 1958 · S/N 51029N492ERWings Over Kauai LLC · Kalaheo, HIS/N 172S8946N492PCTextron Aviation Inc · Wichita, KSS/N 172S13660N492SFSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 17268310N492SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8033N492WPAngel Aviation Inc · Peoria, AZBuilt 1979 · S/N 17272684N4930ACapra Cory · Forest Lake, MNBuilt 1956 · S/N 32327N4930DToribio LLC · San Antonio, TXS/N 51030N4930NOneill Aviation LLC · Lake Wales, FLBuilt 1977 · S/N 21062421N4930RSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802447TN4931CEinstein Inc · Price, UTBuilt 1975 · S/N 18502662N4931RRegistration Pending · Westhope, NDRegistration pendingBuilt 1975 · S/N 18802448TN4932ALegas David S · Phoenix, AZBuilt 1956 · S/N 32329N4932NSan Juan Flyers Inc · Pagosa Springs, COBuilt 1979 · S/N 18267460N4933QDarter Lloyd R · Mountain Grove, MOBuilt 1976 · S/N 18802668TN4934AYellowstone Overflight Inc · Belgrade, MTBuilt 1956 · S/N 32331N4934EHeineman Steven · Chicago, ILBuilt 1979 · S/N 18503912N4934USatriana Robert L · Belen, NMBuilt 1965 · S/N 21058634N4935AVucetic Miroslav · Coral Springs, FLBuilt 1956 · S/N 32332N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482N4935QHaygar Berlin Inc · Shorewood, MNBuilt 1978 · S/N 18503578N4936AAnderson Dennis G · Eagle River, AKBuilt 1956 · S/N 32333N4936NSwett Alan · Panora, IABuilt 1979 · S/N 18267463N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484N4937RAllred Bobby A · Centre, ALBuilt 1975 · S/N 18802454TN4939CBard Ralph M · Tullahoma, TNBuilt 1979 · S/N 21063680N4939RMiller Farms Jv · Opheim, MTBuilt 1975 · S/N 18802456TN4939VFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1980 · S/N 172RG0420N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050N4939ZStaheli Lee E · Kiana, AKS/N U20606053N493BTRegistration Pending · Deltona, FLRegistration pendingBuilt 1975 · S/N 17702318N493CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282265N493EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12260N493JLPhoenix Flyers Inc · Mesa, AZBuilt 1998 · S/N 18280138
Back to AD 79-10-14 R1