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.

N597SPViolet Sparkle Pearl LLC · Hanover, NHBuilt 2000 · S/N 172S8525N597TTTerrell David R · Smithville, TNBuilt 1969 · S/N 17701403N597TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13229N5980AFinstad Brandon C · South Weber, UTBuilt 1956 · S/N 28580N5980EHarris Kenneth L · Greeley, COS/N 17480N5980GBall Albert N · Chugiak, AKBuilt 1969 · S/N 15071480N5980RPetes LLC · Pompton Plains, NJBuilt 1965 · S/N 17253649N5981ENelson David F · Onalaska, WAS/N 17481N5981RKenney Anthony G · Oviedo, FLBuilt 1965 · S/N 17253650N5981TLowe David · Sacramento, KYS/N 15060681N5982EAblaihan Inc · Angels Camp, CABuilt 1959 · S/N 17482N5982FCharles James Brown · Littlefield, TXS/N 21058982N5982TLifto Thomas W · Barronett, WIBuilt 1964 · S/N 15060682N5983BNck Consulting LLC · Scottsdale, AZBuilt 1956 · S/N 33983N5983ESweet R Kent Trustee · Reno, NVBuilt 1983 · S/N 18268341N5983JIlarraza Gilberto C · Sabana Hoyos, PRS/N 17273848N5983MPhilipp Michael W · Thief River Falls, MNS/N 17260945N5984Eberle Larry L · Humble, TXBuilt 1971 · S/N 18260841N5984FFct Aviation LLC · Portales, NMBuilt 1968 · S/N 21058984N5984GClifton Raymond L · Pleasanton, TXS/N 15071484N5984JZogleman Enterprises Inc · Viola, KSBuilt 1975 · S/N 18263599N5985ARimes Aviation LLC · Worthngtn Spg, FLBuilt 1956 · S/N 28585N5985EAlderman Melvin R · Jacksonville, FLBuilt 1959 · S/N 17485N5985GStanton Aviation Lc · Saint George, UTBuilt 1969 · S/N 15071485N5985JRuby Crest LLC · Girdwood, AKBuilt 1975 · S/N 18263600N5986FBingham Darold R · Idaho Falls, IDBuilt 1968 · S/N 21058986N5987ALong Randy M · Dewy Rose, GABuilt 1956 · S/N 28587N5987GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801166N5987JBoerne Flight Options LLC · Boerne, TXS/N A1500287N5988AHiggins Jeffery D · Minden, NVBuilt 1956 · S/N 28588N5988BLarsen Christopher S · Pleasanton, CAS/N 33988N5988TInvestopia Online LLC · Houston, TXS/N 15060688N5989ABrokaw Terry L · Three Rivers, MIBuilt 1956 · S/N 28589N5989ESchiller Gregory L · Pittsburg, NHBuilt 1959 · S/N 17489N5989TKnudtson Bruce A · Sioux Falls, SDBuilt 1964 · S/N 15060689N598ABBrynelsen Charles R · North Oaks, MNBuilt 1976 · S/N 18503136N598MCTeichroeb Peter · Seminole, TXBuilt 1998 · S/N 18280206N598SPFb Aviation LLC · Minot, MEBuilt 2000 · S/N 172S8526N5990EManeuvering Speed Inc · Wilmington, DEBuilt 1978 · S/N 17271980N5991EWilliford Travis C · Sandersville, GAS/N 17491N5991JSchutes John T Jr · Port St Joe, FLBuilt 1971 · S/N A1500291N5991TDelima Joseph D · Livermore, CAS/N 15060691N5992GPerry Aaron O · Piqua, OHS/N 15071492N5992JLinback Ken R · Niles, MIBuilt 1971 · S/N A1500292N5993ETss Flying Club Inc · Bethesda, MDBuilt 1978 · S/N 17271981N5993GSchoenrock Timothy · Stillman Valley, ILBuilt 1969 · S/N 15071493N5994EMccallister Shawn D · Hendersonville, NCBuilt 1959 · S/N 17494N5994TBundgard Peter A · Natchez, MSBuilt 1964 · S/N 15060694N5995AOanes Kenneth W · Merrillan, WIBuilt 1956 · S/N 28595N5995BWilson Robert E III · Urbanna, VABuilt 1956 · S/N 33995
Back to AD 79-10-14 R1