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.

N24159Power Alan T · Los Alamos, NMBuilt 1982 · S/N 18504346N2415FTrutschel Steven R · Waynesville, OHBuilt 1965 · S/N 18051615N2415L98x LLC · Caddo Mills, TXS/N 17255615N2415QPagel David R · Tioga, NDBuilt 1966 · S/N 18257615N2415RRegistered aircraftBuilt 1964 · S/N 18255515N2416CTa Ritchey LLC · Batavia, OHBuilt 1954 · S/N 30716N2416LBeck Roger M Trustee · Goode, VABuilt 1966 · S/N 17255616N2416QAltitude Addiction LLC · Harker Heights, TXS/N 18257616N2416USzabo Stephen A · Sacramento, CABuilt 1963 · S/N 17250016N2417CW & K Aviation LLC · Omro, WIS/N 30717N2417EWolthuis Ivan H · Sweet Home, ORS/N 17271274N2417LBox Aviation Inc · Montgomery, ALBuilt 1966 · S/N 17255617N2417QMcgough Julie Eileen · Red Oak, TXS/N 18257617N2417RJohary Aviation Inc · Apopka, FLS/N 18255517N2417SPiasecki Aircraft Corporation · Coatesville, PABuilt 1967 · S/N 337-0717N2417XGerding Thomas P · Philomath, ORBuilt 1965 · S/N 18256317N24187Heil Brad C · Homer, AKBuilt 1972 · S/N 18502031N2418CBlythe Anne T · Paso Robles, CABuilt 1954 · S/N 30718N2418DRogers Colin · Nevada City, CABuilt 1952 · S/N 20570N2418GSunset Cay Orc Partners LLC · Key Largo, FLS/N 51718N2418LF Sharp Aviation LLC · New Baltimore, MIBuilt 1966 · S/N 17255618N2418SThomas Michael Ray · Marshall, MOBuilt 1967 · S/N 337-0718N2418UGronning Chris D · Anchorage, AKBuilt 1963 · S/N 17250018N2418XPoessel Frank George Jr · East Bernard, TXBuilt 1965 · S/N 18256318N2419DHansen Michael C · Roseville, CABuilt 1952 · S/N 20571N2419FMartinez Rudy J · Wasilla, AKBuilt 1965 · S/N 18051619N2419GBig Sky Aviation LLC · Kapaau, HIBuilt 1958 · S/N 51719N2419JScheller Dwain A · Grand Rapids, MIBuilt 1966 · S/N 15065519N2419L2419l LLC · Jackson, MIBuilt 1966 · S/N 17255619N2419QScholl Steven G · Bluffton, SCBuilt 1966 · S/N 18257619N2419RLynch Gerald A · Santa Barbara, CABuilt 2000 · S/N 18280927N2419YBaker Adam W · Germantown, TNBuilt 1962 · S/N 17249719N241ABTextron Aviation Inc · Wichita, KSS/N 172S13627N241AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281182N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563N241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889N241EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2024 · S/N 172S13238N241JJN241jj LLC · Louisville, KYBuilt 2025 · S/N 18283313N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602N241ME#430b LLC · Bruce Township, MIBuilt 2000 · S/N 18280761N241NYColonial Aviation LLC · N Prince George, VAS/N 17256479N241PFForsyth Huston J · New Orleans, LAFirst renewal noticeBuilt 1973 · S/N 15075274N241PLAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276422N241RDRegistration Pending · Missoula, MTRegistration pendingBuilt 1975 · S/N 18502934N241RGAmerican Patrols Inc · Midland, TXBuilt 1973 · S/N 17261916N241RRRoss Riley C · Colorado Springs, COS/N 15073611N241SRLeman Joseph A · Anchorage, AKBuilt 1965 · S/N 18256316N241WMWildman Air LLC · Mckinney, TXBuilt 1973 · S/N 18502253N24200Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13114N24201Suhr Douglas Henry Jr · Oil City, PABuilt 2007 · S/N 18281954
Back to AD 79-10-14 R1