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.

N5156AFrantz Douglas M · Mustang, OKS/N 28156N5156ESchwankl Michael James · Wasilla, AKBuilt 1959 · S/N 50456N5156JWings Over La Aviation LLC · West Hills, CABuilt 1979 · S/N 17273718N5156QN5156q Inc · Elmhurst, ILFirst renewal noticeBuilt 1972 · S/N 21059656N5156RKookaburra Kiwi LLC · Post Falls, IDBuilt 1974 · S/N 17263373N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100N5157DPari Gabe M · Ontario, CABuilt 1958 · S/N 51257N5157KWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1980 · S/N 17273993N5157NAms Aviation LLC · South Bend, INBuilt 1980 · S/N 18267549N5157VHarwig Robert P · Longville, MNBuilt 1977 · S/N R1722279N5157ZAspire Aviation LLC · Farmingdale, NYBuilt 2002 · S/N 172S9026N51580Middletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1980 · S/N 17274323N51582Flight School Of Gwinnett Inc · Lawrenceville, GAFirst renewal noticeBuilt 1981 · S/N 17274324N5158EHuettl Austin · Liberty Hill, TXBuilt 1978 · S/N 17271743N5158JTfs Air LLC · Loveland, COBuilt 2002 · S/N 172S9027N5158QAnglin Cheryl · Jackson, MSBuilt 1973 · S/N 17261769N5158RBrandenburg Idu LLC · Brenham, TXBuilt 1974 · S/N 17263375N51590Kadena Aero Club · Apo, APS/N 172S9030N51594Candace A Larned Enterprises Inc · Long Beach, CABuilt 1980 · S/N 17274326N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292N5159DFleming James Daniel · Kansas City, MOBuilt 1958 · S/N 51259N5159NO Bleness Kevin W · Bethel, AKBuilt 1980 · S/N 18267550N5159RBackcountry Adventures LLC · Big Lake, AKBuilt 1976 · S/N 18503011N5159UPostolnikov Paul V · Graham, WABuilt 1980 · S/N 172RG0265N515CLProfessional Pilot Services LLC · Miami, FLS/N 18255135N515EDBlue Sky Pilots Inc · Salem, ORBuilt 1975 · S/N 17265354N515HE2f Trade LLC · Gainesville, TXS/N 21061457N515KPKading Air LLC · Urbandale, IABuilt 2020 · S/N 18283113N515LXJones Johnny V · Crab Orchard, KYS/N 17250603N515MAAdams Scott M · Seabrook, TXS/N 1851070N515MBMoxie Air LLC · Winston Salem, NCBuilt 1982 · S/N 18268202N515NAikens Susan R · Delta Junction, AKBuilt 1951 · S/N 19987N515RDWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264049N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235N515RVFlying Adventures Tm LLC · Talkeetna, AKBuilt 1975 · S/N A1500594N515SPFriedlander Ernest · San Francisco, CABuilt 2000 · S/N 172S8374N51608Commonwealth Of Kentucky · Frankfort, KYBuilt 1967 · S/N R1720255N5160ABowden Aaron C · Yuma, AZBuilt 1955 · S/N 28160N5160DPatton Jay A · Hobbs, NMBuilt 1958 · S/N 51260N5160ELeading Edge Flight Academy LLC · Bend, ORBuilt 1978 · S/N 17271744N5160RTownley Wren Adam T · Orwell, VTS/N 17263377N51614Stillwater Flyers LLC · Columbus, MTBuilt 1981 · S/N 17274330N51616Stardust Aviation LLC · Farmingdale, NYBuilt 1980 · S/N 17274331N5161ASchmid Robert E · Red Bluff, CABuilt 1955 · S/N 28161N5161DKnutson Wayne R · Thompson, NDBuilt 1958 · S/N 51261N5161NLewis Justin R · Frederick, OKBuilt 1980 · S/N 18267552N5161USkyler Aviation · San Diego, CABuilt 1964 · S/N 206-0161N5162ASizer Timothy J · Arthur, NES/N 28162N5162DRodrigues George C · Aiken, SCBuilt 1958 · S/N 51262N5162FLosasso Michaela Marie · Scottsdale, AZBuilt 1979 · S/N 17273120
Back to AD 79-10-14 R1