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.

N2942UHughes Stephen Lee · Dothan, ALBuilt 1963 · S/N 17250542N2942XLewellen Mark A · Pensacola, FLBuilt 1967 · S/N 17700342N29430Mcvicker Max W · Sand Springs, OKBuilt 1968 · S/N 17700882N29432Waddell Bhrent E Trustee · Collinsville, OKBuilt 1968 · S/N 17700883N29434Salvi Marcos · Phoenix, AZS/N 17700884N29436Echelon Sport Aviation LLC · Los Angeles, CAS/N 17700886N29439Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700888N2943AGraham Jason J · Anchorage, AKS/N 30143N2943CBaas Brian · Cambridge, MNBuilt 1954 · S/N 30843N2943UHania Robert · Benicia, CAS/N 17250543N2943XMccormack Robert · Sacramento, CAS/N 17700343N29440Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700889N29441Chan Luen Hei · Hacienda Heights, CABuilt 1968 · S/N 17700890N29442Nance David B · Quinton, VABuilt 1968 · S/N 17700891N29444Pikula Eric Martin · Brainerd, MNS/N 17700893N29448Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1968 · S/N 17700894N29449Brown D W · Wasilla, AKBuilt 1968 · S/N 17700895N2944AWalker Travis J · Wasilla, AKBuilt 1953 · S/N 30144N2944CHenry Kent · Prescott, AZBuilt 1954 · S/N 30844N2944DWeaver Brian J · Livingston, TXBuilt 1955 · S/N 26887N2944FJ3 Contracting Inc · Milton Freewater, ORBuilt 1966 · S/N 18257044N2944JThomas Edward R · Piney Flats, TNS/N 15065744N2944SChartrand Robert J · Brimley, MIBuilt 1967 · S/N 15066844N2944UMillsaps David C · Tuscumbia, ALBuilt 1963 · S/N 17250544N29455Heir Richard T · Lambert, MTBuilt 1968 · S/N 17700899N29459Frana Cody R · Eagle Rock, MOBuilt 1968 · S/N 17700901N2945UGriffith Ronald W Jr · Douglasville, GABuilt 1963 · S/N 17250545N2945VMcclellan Stephanie · Hebron, ILS/N 15076330N29462Thomas Stanley L · Thermopolis, WYBuilt 1968 · S/N 17700904N29467Teel Kevin E · Fallbrook, CAS/N 17700908N29468Cummings Mark R · Laveen, AZBuilt 1968 · S/N 17700909N29469Gem Property Investments LLC · San Antonio, TXBuilt 1968 · S/N 17700910N2946ARuach Ministry · Dover, DES/N 30146N2946CMannis Arthur · Somers, NYBuilt 1954 · S/N 30846N2946EHigh Wing Air Services LLC · Merritt Island, FLBuilt 1978 · S/N 17271380N2946SFreed Michael · Sylmar, CABuilt 1967 · S/N 15066846N2946UPearson Eugene L · Burns, KSS/N 17250546N29474Leslie Jason · Dayton, OHBuilt 1968 · S/N 17700913N29479Kozminski Michael J · Caledonia, WIBuilt 1968 · S/N 17700914N2947CHess Alexander · Virginia Beach, VABuilt 1954 · S/N 30847N2947DMelin Clinton C Trustee · Big Lake, AKS/N 26890N2947FCopeland Matthew S · Wichita, KSBuilt 1966 · S/N 18257047N2947JMaggio Anthony M · Harbor City, CABuilt 1966 · S/N 15065747N29480Cobra Aviation LLC · Kalispell, MTBuilt 1968 · S/N 17700915N29481Walle Heidi N · Coarsegold, CABuilt 1968 · S/N 17700916N29485Lily Anne Aviation LLC · Bad Axe, MIBuilt 1968 · S/N 17700919N29488Luther Charles A · Walnut Creek, CABuilt 1968 · S/N 17700921N2948CTundra House Tailwheel Club LLC · Willow, AKBuilt 1955 · S/N 31730N2948JSale Reported · Ruston, LASale reportedBuilt 1966 · S/N 15065748N2948YWells David · Twin Falls, IDBuilt 1962 · S/N 18253948
Back to AD 79-10-14 R1