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.

N6267CTholl Robert E · Morristown, NJBuilt 1952 · S/N 20490N6267E67 Echo LLC · Las Vegas, NVBuilt 1959 · S/N 46367N6267FSkymaster Company LLC · Dover, DES/N 337-0267N6267TLittleton Roy T III · Ruther Glen, VABuilt 1964 · S/N 15060967N6267YZero Four Twelve LLC · Clovis, NMBuilt 1981 · S/N 21064313N62689Optic Air LLC · Sioux Center, IABuilt 1981 · S/N 17275325N6268AHenshaw Jon R · Miami, FLBuilt 1956 · S/N 33068N6268DSafety In Motion Flight Center Inc · Puyallup, WABuilt 1979 · S/N 17272679N6268EBilton Nicholas J · Bozeman, MTS/N 46368N6268NCompass Rose Aviation · Derby, KSBuilt 1981 · S/N 18267814N6268RYouvan Ian · Pittsburg, KSS/N 31418N6268SHayes Barrett W · Siler City, NCBuilt 1967 · S/N 15067068N6268TBartkowiak Alex M · Moorhead, MNBuilt 1964 · S/N 15060968N62690Aerosim Academy Inc · Sanford, FLBuilt 1981 · S/N 17275326N62694American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275327N6269ABubs Tub LLC · San Angelo, TXBuilt 1956 · S/N 33069N6269DCongressional Flying Club Inc · Gaithersburg, MDBuilt 1979 · S/N 17272680N6269ERule Paul Crane Trustee · Wapato, WAS/N 46369N6269GMattingly Andrew R · New Albany, INBuilt 1970 · S/N 15071769N6269QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10715N626AFCape Fear Pilots LLC · Bald Head Island, NCBuilt 1980 · S/N 172RG0390N626CBWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 172S10734N626DTA & F Aviation Services LLC · Collierville, TNBuilt 1979 · S/N 18266784N626EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13525N626GMMike Smith Aviation International Inc · Napa, CABuilt 2021 · S/N 172S12688N626KTRustair Inc · Anchorage, AKS/N U20604426N626LDAerofleet LLC · Oldsmar, FLBuilt 1973 · S/N 177RG0341N626RPWhitaker Jesse G · Anchorage, AKBuilt 1955 · S/N 31659N626WBBorella Jay D · Bellingham, WAS/N 337M0440N6270RAbout Time Aviation · Springfield, ORBuilt 1979 · S/N 172RG0132N6270SHudson Kelly G · Monroe, NCBuilt 1967 · S/N 15067070N6270XLees Robert A II · Mesa, AZBuilt 1980 · S/N U20605851N6271AAshley Edward A · San Antonio, TXBuilt 1956 · S/N 33071N6271BCountry Flyin Inc · Homestead, FLBuilt 1977 · S/N U20603839N6271ENate Abel Flying Club · Fort Worth, TXBuilt 1958 · S/N 46371N6271GSumpter Kenneth W · Enid, OKBuilt 1970 · S/N 15071771N6271SJay Square Aircraft Inc · Hilton Head Island, SCBuilt 1967 · S/N 15067071N6271TBesteiro Aly E · Brownsville, TXBuilt 1964 · S/N 15060971N62726Xing Kong Aviation Service LLC · Atwater, CAS/N 17281529N6272EFeauto Aviation Inc · Saint Cloud, FLBuilt 1958 · S/N 46372N6272GDunn Michael Thomas · Arlington, VAS/N 15071772N6273AStreufert Colton P · Boise, IDBuilt 1956 · S/N 33073N6273EBunner Corin Anthony · Murfreesboro, TNBuilt 1959 · S/N 46373N62740Doomac LLC DBA · Peyton, COBuilt 1981 · S/N 17275331N6274AA V T210 LLC · Palmdale, CABuilt 1979 · S/N 21063517N6274DOracle Aviation LLC · Omaha, NEBuilt 1979 · S/N 17272685N6274EHuff Air LLC · Uvalde, TXBuilt 1959 · S/N 46374N6274VDollbaum Robert A · Southfields, NYBuilt 1980 · S/N 172RG0604N6275ABrown Thomas C · Littlefield, TXBuilt 1956 · S/N 33075N6275EValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 18504017
Back to AD 79-10-14 R1