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.

N6782HJb Aviation Management Inc · Wonder Lake, ILBuilt 1975 · S/N 17265580N6782RReavis Paul B · Gatesville, TXBuilt 1966 · S/N T210-0182N6783RHarness Jesse J · Peoria, AZBuilt 1966 · S/N T210-0183N6784AAtlantic Rotors LLC · Saint Inigoes, MDBuilt 1956 · S/N 28884N6784ESwedberg Randy M · Kingman, KSS/N 56284N6784RVolk Kenneth L · Waskom, TXBuilt 1966 · S/N T210-0184N6785MRocerick Dean G · The Dalles, ORBuilt 1975 · S/N 18263834N6785RRood Enterprises LLC · Livingston, TXBuilt 1966 · S/N T210-0185N6785SSchmidt Gary C · Sunrise Beach, MOBuilt 1967 · S/N 15067585N6786ARutledge Brett B · Yuma, COS/N 28886N6786FBeitz Norman Roy · Quitman, TXS/N 15063386N6787HGordon Caleb J · Waukesha, WIBuilt 1975 · S/N 17265582N6787RJensen Leland · Idaho Falls, IDBuilt 1966 · S/N T210-0187N6788MEs Limited · Edmond, OKS/N 18263836N6789AChris Fuher Flight Instruction LLC DBA · Townsend, MTS/N 28889N6789EHeinen Avionics LLC · Adrian, MIBuilt 1959 · S/N 56289N6789KDrc Equipment LLC · Caldwell, IDBuilt 1976 · S/N 182-65066N6789MPlane Services LLC · Twin Falls, IDBuilt 1975 · S/N 18263837N6789RDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N T210-0189N678AAWings Over Texas Holdings LLC · Denton, TXS/N 172S10663N678GHHamilton Gilbert R · Leesburg, VABuilt 1977 · S/N 177RG1283N678JBSierra Flyers Inc · Incline Village, NVBuilt 1980 · S/N 18267541N678KPalm Steven · Madera, CABuilt 1956 · S/N 29454N678NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2015 · S/N 172S11619N678RBBoldflight LLC · Bargersville, INBuilt 2012 · S/N 172S11179N678RMLaw Roger Jay · Franklin, INBuilt 1961 · S/N 17248390N678SPFreed Bryan S · Norfolk, VABuilt 1999 · S/N 172S8089N678WLanghoff John A · Yoakum, TXBuilt 1969 · S/N 18259757N678WWFly Cessna LLC · Peoria, AZBuilt 2000 · S/N 172S8678N6790ALaurel 406 Aero · Billings, MTS/N 28890N6790GMartin Christopher G · Monessen, PABuilt 1970 · S/N 15072290N6790SHildreth Jon R · Spencer, WVBuilt 1967 · S/N 15067590N6792FPatton Aviation LLC · Billings, MTBuilt 1966 · S/N 15063392N6792MHouck Mary M · Fish Creek, WIBuilt 1975 · S/N 18263839N6792RKenley Fredrick C · Palmer, AKBuilt 1980 · S/N 18053156N6792SJohnston Robert G · Rose Hill, KSBuilt 1967 · S/N 15067592N6793AJones Jeffrey D Trustee · Elida, OHBuilt 1956 · S/N 28893N6793EBig South Fork Aerospace LLC · Pine Knot, KYBuilt 1959 · S/N 56293N6793FOgden John T · Meridian, IDBuilt 1966 · S/N 15063393N6793GExecutive Flight Institute LLC · Murrieta, CABuilt 1970 · S/N 15072293N6793RDelevie Mark Y · Tucson, AZBuilt 1966 · S/N T210-0193N6794EWalls Jerry L · Hawley, TXS/N 17272067N6794GLawson Kurt J · Melbourne, FLBuilt 1970 · S/N 15072294N6794HPs N6794h LLC · Green Bay, WIBuilt 1975 · S/N 17265583N6795AKelley Aviation Services Inc · Halifax, PAFirst renewal noticeBuilt 1956 · S/N 28895N6796AAjer Richard L · Herriman, UTBuilt 1956 · S/N 28896N6796EBlain Kyra · Conroe, TXFirst renewal noticeBuilt 1978 · S/N 17272068N6796GLyon Scott T · Wellsville, KSBuilt 1970 · S/N 15072296N6796HAmelia Reid Aviation LLC · San Jose, CABuilt 1975 · S/N 17265584N6796SRegistration Pending · Lawrence, KSRegistration pendingS/N 15067596
Back to AD 79-10-14 R1