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.

N6386FRasys Paul J · Lawton, OKBuilt 1966 · S/N 337-0386N6386GSonafrank Eric · Somerset, INBuilt 1970 · S/N 15071886N6386VSaunders Andreas · Wake Forest, NCS/N 172RG0649N6387FMitich Nathan · Fort Worth, TXBuilt 1980 · S/N 17273214N6388DBdo Aviation LLC · Dallas, TXBuilt 1979 · S/N 17272774N6388GGaller Frank G · Elysian, MNBuilt 1970 · S/N 15071888N6388YMaclean Kenneth J · Northborough, MABuilt 1981 · S/N 21064359N6389FSymms Fruit Ranch Inc · Caldwell, IDBuilt 1975 · S/N 18264185N6389GHagen Alfred · Bensalem, PABuilt 1970 · S/N 15071889N638AGSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11464N638CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281533N638CTCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10781N6390BPalmer Bryce P · Chugiak, AKBuilt 1957 · S/N 34290N6390ERyan Michael P · Melrose, IAFirst renewal noticeBuilt 1959 · S/N 46490N6390SStraub Aircraft Holdings LLC · Overland Park, KSBuilt 1967 · S/N 15067190N63918Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275495N6391EDay Stephen F · Queen Creek, AZBuilt 1959 · S/N 46491N6391JAty Aviation Inc · Watertown, SDBuilt 1980 · S/N 17273868N6391UGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N U20605472N63921Nc Division Of Marine Fisheries · Morehead City, NCBuilt 2004 · S/N 18281408N6392ARlf Aviation LLC · Peachtree Corners, GABuilt 1956 · S/N 33192N6392BHubatka Wilferd · Creston, IAFirst renewal noticeBuilt 1957 · S/N 34292N6392CTretter Nicholas · Holden, MABuilt 1980 · S/N 21063880N6392EWinds Aloft Inc · Lakeland, FLBuilt 1983 · S/N 18268366N6392GJtw Aero Leasing LLC · Frederick, MDBuilt 1979 · S/N 17273592N6392YBoldflight LLC · Greenwood, INBuilt 1975 · S/N 17264795N6392ZFlorence Michael · Portsmouth, NHBuilt 1981 · S/N U20606264N6393ALadmill Investments LLC · Gulfport, MSBuilt 1956 · S/N 33193N6393BLebard Racquele J · Sparks, NVBuilt 1957 · S/N 34293N6393EBrewster Richard D · Bellvue, COBuilt 1959 · S/N 46493N6393GKrusell Robert S · Blairsville, GABuilt 1979 · S/N 17273593N6393RGilbert John · Austin, TXBuilt 1979 · S/N 172RG0176N6394BPepitone David D · Santa Fe, NMS/N 57459N6394DManzur Miguel Antonio · Mcallen, TXBuilt 1977 · S/N 21062010N6394EMilco Airways Inc · River Hills, WIBuilt 1978 · S/N 17272014N6394FScowden Wendell R · Piketon, OHBuilt 1975 · S/N 18264187N6394SLincoln Air LLC · Kalispell, MTBuilt 1968 · S/N 182-59002N6394VRice Aviation · Maddock, NDBuilt 1980 · S/N 172RG0656N63958Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275501N6395ARose City Soaring Association Inc · Valdosta, GABuilt 1956 · S/N 33195N6395BMb Laster Aviation LLC · Eagle, COBuilt 1957 · S/N 34295N6395DBirks Jeffrey R · Nokesville, VABuilt 1979 · S/N 17272781N6395EStott David L · Wasilla, AKBuilt 1959 · S/N 46495N6395FSalisbury Neilan · Trabuco Canyon, CABuilt 1975 · S/N 18264188N6395ZN Berk Consultant Inc · Greenwich, CTBuilt 1981 · S/N U20606266N6396BGeezer Guys LLC · Eloy, AZBuilt 1957 · S/N 34296N6396DOc Flight Lessons LLC · Costa Mesa, CABuilt 1979 · S/N 17272782N6396ELecrone Craig W · Duncansville, PAS/N 18268367N6396FKing Emily · Laramie, WYS/N 337-0396N6397BLayson Walter E · Calhoun, GABuilt 1978 · S/N 21062758
Back to AD 79-10-14 R1