OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N1774FBarnstormers Aero Services Inc · Lompoc, CABuilt 1966 · S/N 17255169N1774HPeacock Bruce M · Mendon, VTBuilt 1980 · S/N 18267507N1774TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12111N1774VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263747N1775QBrooks Timothy J · Oshkosh, WIS/N 15073075N1775RAnderson Lenny R · King Salmon, AKBuilt 1974 · S/N 18502494N1776DRobbins Flight Training LLC · Bakersfield, CABuilt 1951 · S/N 20219N1778FBlake Brian R · Irvine, CABuilt 1966 · S/N 17255173N1778MSeitz David C · Gordonville, TXS/N 21061958N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378N1779DSchrag Jeremy M · Garden Plain, KSBuilt 1951 · S/N 20222N1779MBlagg Kevin · Dumas, ARBuilt 1975 · S/N 18264439N1779ZLewis Lionel · Tacoma, WABuilt 1963 · S/N 336-0079N177AWolter Aviation LLC · Charleston, SCBuilt 1975 · S/N 17702284N177AAKnowles Mark A · Gun Barrel City, TXBuilt 1975 · S/N 177RG0765N177AMAdler A Michael · Bend, ORBuilt 1976 · S/N 177RG0941N177APThunderbird Aviation LLC · Littleton, COBuilt 1972 · S/N 177RG0304N177ARHull Jared Gene · Redondo Beach, CABuilt 1975 · S/N 177RG0782N177ASManning Bryan E · Northport, ALBuilt 1968 · S/N 17700967N177AVMy Airline LLC · Harrods Creek, KYBuilt 1976 · S/N 177RG0889N177AWFarni Edward C III · Billings, MTBuilt 1970 · S/N 17701516N177BStocks Aviation And Machine Inc · Wilmington, DES/N 17702350N177BAAnderson David J · Saint Johns, FLS/N 17701449N177BCCraig William Richard · Vandalia, OHBuilt 1972 · S/N 17701803N177BGAccurso Steven M · Marietta, GAS/N 17702449N177BHAircraft Trade Group LLC · Scandia, MNS/N 17701411N177BLMontgomery David · Oak Park, ILBuilt 1976 · S/N 17702425N177BSWilliams James E · Kirkwood, MOBuilt 1978 · S/N 177RG1017N177BTPlane Data Inc · Terrell, NCBuilt 1977 · S/N 177RG1194N177BVGhostrider Aviation Inc · Bohemia, NYS/N 177RG1288N177BWRegistered aircraftBuilt 1972 · S/N 17701756N177BZZotter Brand LLC · Vero Beach, FLBuilt 1971 · S/N 177RG0058N177CCHoel Martin J · Waterloo, IABuilt 1967 · S/N 17700654N177CELedley Charles F · Pasadena, MDBuilt 1978 · S/N 177RG1308N177CFGregoire Surgical Inc · Springfield, ILBuilt 1971 · S/N 17701632N177CJCuneo Christopher G · Jupiter, FLBuilt 1970 · S/N 177RG0018N177CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282338N177CVZinkel Gregory S · Leander, TXS/N 17700640N177DBarger Randall G · Newport News, VABuilt 1973 · S/N 17702012N177DAParry Thomas J · White Post, VABuilt 1977 · S/N 17702617N177DCBastian Justin Paul · Chubbuck, IDBuilt 1973 · S/N 177RG0335N177DHAhp LLC · Kirkland, WAS/N 17702001N177DKKeen David S · Amherst, NHBuilt 1967 · S/N 17700567N177DRDilorenzo Brian E · Palmyra, VABuilt 1973 · S/N 177RG0379N177DWJones Stephen L · Cypress, TXBuilt 1973 · S/N 177RG0338N177EBDodd Lisa · Sandpoint, IDBuilt 1967 · S/N 17700562N177EELiebeler Susan Trustee · Malibu, CABuilt 1976 · S/N 17702511N177EFCivitarese Nicholas G · Furlong, PABuilt 1976 · S/N 177RG1008N177EJDouble A Flight Services LLC · Edinburg, TXBuilt 1971 · S/N 17701626N177ETThorstad Aviation LLC · Alexandria, MNBuilt 1976 · S/N 17702378
Back to AD 79-10-14 R1