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.

N91156Scarlett Ryan Jay · Sparks, NVBuilt 1973 · S/N 18261959N91157Garza Aircraft Inc · Harlingen, TXBuilt 1969 · S/N 20700096N9115BParker Justin S · Elko, NVBuilt 1958 · S/N 36615N9115THigginbothan Stewart C · Woodbine, GABuilt 1959 · S/N 50615N9115UWigley Ben F Jr · Huntington, ORFirst renewal noticeS/N 15078066N91160Brown Jeffrey C · Saint Augustine, FLBuilt 2011 · S/N 18282297N91162Kelley Patrick J · Catawba, NCBuilt 1973 · S/N 18261960N9116BS Dacy Enterprises Inc · Harvard, ILBuilt 1958 · S/N 36616N9116GJones Brian E · Painted Post, NYFirst renewal noticeBuilt 1971 · S/N 18260656N9116XTaylor Aviation Inc · Fort Benton, MTBuilt 1961 · S/N 18253516N91170Paklook Air Inc · Bethel, AKBuilt 1969 · S/N 20700101N9117BPartridge John R · Manchester, NHS/N 36617N9117GAndrews Mimi Muldrow · Hilltop Lakes, TXBuilt 1971 · S/N 18260657N9117MPettigarrett LLC · Manchester, GABuilt 1976 · S/N 18264685N9117TMichaud Paul K · Forest Lake, MNBuilt 1959 · S/N 180-50617N9117UBahr Timmy A · Crandon, WIBuilt 1976 · S/N 15078068N91183Hatch Hyrum G · Gilbert, AZBuilt 1969 · S/N 20700106N9118BCulpeper Aviation LLC · Queen Creek, AZBuilt 1958 · S/N 36618N9118THagen Bruce L · Reeder, NDBuilt 1959 · S/N 50618N9118U9118u LLC · Dover, IDBuilt 1976 · S/N 15078069N91190Renfro Michael W · Bethel, AKBuilt 1969 · S/N 20700109N91199Olmstead Daniel H · Kimberly, IDBuilt 1973 · S/N 18261967N9119ATorraca Peter · New York, NYBuilt 1958 · S/N 19349N9119GWinters Richard Linn · Chandler, AZBuilt 1971 · S/N 18260659N911ATW I F A (Washington International Flight Acad) LLC · Gaithersburg, MDS/N 17275869N911BWOlsen Garry O · Forest Lake, MNS/N 32863N911EWeiss Elliott · Fresno, TXS/N 20700747N911JTSchaefer Kent M · Anacortes, WABuilt 1957 · S/N 34629N911LAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280639N911MCKing Daddy Aviation LLC · Madison, MSS/N 21057773N911MDAirplex Aircraft LLC · Springfield, MOBuilt 1957 · S/N 34174N911PBaldwin Andrew W · Lander, WYBuilt 1971 · S/N 172-60321N9120CFrison Joseph · Milton, WIBuilt 1954 · S/N 31219N9120GRoderi Air LLC · Berlin, MDBuilt 1971 · S/N 18260660N9120HKrieg Kristi · Tonasket, WAS/N 17265954N9120XStevens Matthew J · Onaway, MIBuilt 1961 · S/N 18253520N9121CBowser Justin · Colorado Springs, COBuilt 1954 · S/N 31220N9121HTwenty-One Flyers Inc · Norwalk, CTBuilt 1975 · S/N 17265955N91220Wall Christopher Kenneth · Rochester, NYBuilt 1968 · S/N 18052007N91221Marvin Ray · Tomahawk, WIS/N 19034/2N91223Taylor James R · Murfreesboro, TNBuilt 1969 · S/N 18052009N91224Peninsula Aero Technology Inc · Kenai, AKBuilt 1969 · S/N 18052010N91225Woodaman James G · Pasadena, CABuilt 1969 · S/N 18052011N9122CJohnson Joseph S · Eagle River, AKS/N 31221N9122TWerth Lance C · Johnson Lake, NEBuilt 1959 · S/N 50622N9122XBissell Lee G · Culver, ORBuilt 1961 · S/N 18253522N91230Cutting & Sektnan Inc · Mcminnville, ORBuilt 1969 · S/N 18052016N91231N91231 LLC · Columbia, MOBuilt 1973 · S/N 18261976N91236Skylane 73 LLC · Altadena, CABuilt 1973 · S/N 18261980N9123ASale Reported · Draper, UTSale reportedBuilt 1956 · S/N 18882
Back to AD 79-10-14 R1