OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N3905QH&H Cloudbase Aviation LLC · Carlsbad, CAS/N 17260005N3905RShea Michael P · Nashua, NHBuilt 1966 · S/N 17255405N3906RHorning Richard · Galion, OHS/N 17255406N3906UBrighton Flying Club LLC · Brighton, MIBuilt 1965 · S/N 15061306N3906YWildbur Mark B · Laramie, WYBuilt 1964 · S/N 21058406N3907FTaylor William Bc · Quincy, CABuilt 1958 · S/N 36807N3907GMid-America Sport Parachute Club · Taylorville, ILBuilt 1967 · S/N U206-0907N3907L33 Global LLC · Potomac Falls, VABuilt 1965 · S/N 17254076N3907RNexgen Aviation LLC · Ennis, TXBuilt 1966 · S/N 17255407N3907SWilliamson Henry H · Conway, SCBuilt 1964 · S/N 17251107N3907UDenton Brian H · Poughquag, NYBuilt 1965 · S/N 15061307N3907VSortland Mitchell Kent · Parkersburg, IABuilt 1948 · S/N 18217N3907YAckley John · Brownsville, TXBuilt 1964 · S/N 21058407N3908DMoors Greg K · Athol, IDBuilt 1957 · S/N 34608N3908JSpanaflight LLC · Puyallup, WAS/N 15065208N3908QShamrock Flying Service LLC · Denver, COBuilt 1971 · S/N 17260008N3908RDobson James Cody · Paradise, UTBuilt 1966 · S/N 17255408N3908VKaiser Jimmy · Lake Park, MNBuilt 1948 · S/N 18218N3909CJames Eric A · Claremore, OKBuilt 1968 · S/N 17257032N3909DDavidson Danny F · Anchorage, AKBuilt 1957 · S/N 34609N3909LBlakeley David · Lancaster, NYBuilt 1965 · S/N 17254078N3909QAdventure Seaplanes LLC · Tower, MNBuilt 1971 · S/N 17260009N3909SManer Lawrence L II · Lexington, SCBuilt 1964 · S/N 17251109N3909UGator Aircraft Industries Inc · Winter Springs, FLS/N 15061309N390DMGurrola Joseph C · Redlands, CABuilt 1969 · S/N 15070334N390MEMccabe Eugene · Fremont, CABuilt 2000 · S/N 18280862N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514N3910JNishikawa David H · Davis, CABuilt 1966 · S/N 15065210N3910LHickerson Sherman · Broken Bow, OKS/N 17254079N3910SBenzing Blaine L · Caledonia, MNBuilt 1963 · S/N 17251110N3911FSpencer Jeffrey D · Rushsylvania, OHBuilt 1958 · S/N 36811N3911QTraining Planes LLC · Tampa, FLBuilt 1971 · S/N 17260011N3911RPurcell Keith A · Lima, OHS/N 17255411N3911UGolon Anthony S · Rush City, MNBuilt 1965 · S/N 15061311N3911VMckenzie James A · Corvallis, ORS/N 18221N3912DPmn Enterprises LLC · Fremont, WIBuilt 1957 · S/N 34612N3912RBayshore Safety · Pittsburg, CAS/N 17255412N3912SWalters Gregory · Neodesha, KSS/N 17251112N3913FTailwinds Inc · Lancaster, PABuilt 1958 · S/N 36813N3913JGecsey Sandor · Budd Lake, NJBuilt 1966 · S/N 15065213N3913RClaudy Steven A · Jessup, MDBuilt 1966 · S/N 17255413N3914DKapowsin Air Sports Ltd · Shelton, WABuilt 1957 · S/N 34614N3914QAmerican Patrol Inc · Midland, TXBuilt 1971 · S/N 17260014N3914SMdz Aviation LLC · Orlando, FLBuilt 1964 · S/N 17251114N3914VBodnar Axel R · Wasilla, AKBuilt 1948 · S/N 18224N3915DCarlson Thomas J · Gilbert, MNS/N 34615N3915FBennett Brandon Scott · Fort Worth, TXBuilt 1958 · S/N 36815N3915UPullum Linda A · Goddard, KSBuilt 1965 · S/N 15061315N3916JTrimble Aviation Services LLC · Atlanta, GABuilt 1966 · S/N 15065216N3916RRegistered aircraftBuilt 1966 · S/N 17255416
Back to AD 79-10-14 R1