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.

N50532Cartagena Alfonso · Winter Springs, FLBuilt 1968 · S/N 15069378N50535Harrell Lewis H · Pontotoc, MSS/N 15069380N50538Dunes Aircraft Corporation Inc · Howell, MIS/N 15069382N5053AKing David · Frisco, COBuilt 1955 · S/N 28053N5053DRancho Equipment Leasing LLC · Brownsville, TXBuilt 1958 · S/N 51153N50541W Air LLC · Wheeling, ILBuilt 1968 · S/N 15069384N50544Kidd Ronnie E · Ramseur, NCS/N 15069386N50545Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10889N5054AGrimmonpre Gary · Huntley, ILBuilt 1955 · S/N 28054N5054DK&L Tech Inc · Adams, NEBuilt 1958 · S/N 51154N5054HParker James C · Cuthbert, GABuilt 1975 · S/N 17265320N5054XBlackmon Tommy J · Abilene, TXS/N 18393N50550Registered aircraftS/N 15069391N50551Barreto Daniel · Enterprise, ALBuilt 1968 · S/N 15069392N50555Whalen John · West Ossipee, NHBuilt 1968 · S/N 15069396N5055AN5055a LLC · Clayton, GABuilt 1955 · S/N 28055N5055DBurns Greg K · Pataskala, OHBuilt 1958 · S/N 51155N5055HShaka Skies LLC · Kihei, HIBuilt 1975 · S/N 17265321N5055RGreat Lakes Air Ventures LLC · Mason, MIBuilt 1974 · S/N 17263295N5056EHill Kelly · Bagdad, AZBuilt 1958 · S/N 50356N50574Pope Gregory S · Jacksonville, ILBuilt 1968 · S/N 15069405N50577Diaz Ernesto · Oxnard, CABuilt 1968 · S/N 15069408N50578Mccann Michael H · Springfield, ORBuilt 1968 · S/N 15069409N5057ASoar Above Flight Solutions LLC · Englewood, TNBuilt 1955 · S/N 28057N5057DLatham Travis W · Round Rock, TXBuilt 1958 · S/N 51157N5057HAjf Enterprises LLC · Des Moines, IABuilt 1975 · S/N 17265322N5057RHeise Roger H · Clayton, NYBuilt 1974 · S/N 17263296N50580Freeman Jeffrey E · Iron Mountain, MIBuilt 1968 · S/N 15069411N50581Pritchett Otis R · Avery, TXS/N 15069412N50583Registration Pending · Bentonville, ARRegistration pendingBuilt 1968 · S/N 15069414N5058ABeiter John A · Cle Elum, WABuilt 1955 · S/N 28058N5058USkyler Aviation Inc · San Diego, CABuilt 1963 · S/N 206-0058N50590Usaeroflight LLC · Greenville, SCBuilt 1974 · S/N 17264212N50596Phillips John H · Vernal, UTBuilt 1968 · S/N 15069423N5059ASmith Rickey A · Divernon, ILS/N 28059N5059CLewis University · Romeoville, ILS/N 17281122N5059DJk Aviations LLC · Yardley, PABuilt 1958 · S/N 51159N505ABFredrickson Kenneth · Port Angeles, WABuilt 1974 · S/N 18263391N505CACarver David N · Sanger, CABuilt 1975 · S/N 15076821N505CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283070N505FNovotny Paul A · Elk River, MNBuilt 1964 · S/N 17251911N505JJAero Davis LLC · Camden, DEBuilt 1958 · S/N 46086N505JRParker Matthew · Cloudcroft, NMS/N 18253919N505LMKennicott Wilderness Air LLC · Glennallen, AKS/N 31267N505LPWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 2000 · S/N 172S8546N505PDSargent Evan · Camas, WABuilt 1971 · S/N 18260611N505PPOnionaire LLC · Aurora, ILBuilt 2025 · S/N 18283318N505SWBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 21061185N505WAAtlanta Technical College · Atlanta, GABuilt 1976 · S/N 15077942N50606Siderwicz Christopher J · Marstons Mills, MABuilt 1968 · S/N 15069429
Back to AD 79-10-14 R1