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.

N23357603 Flight LLC · Nashua, NHS/N 15068898N23359Moore Everett A · New Lexington, OHBuilt 1968 · S/N 15068900N2335DWinch Cary F · Necedah, WIS/N 20487N2335EMindy Limited LLC · Muscatine, IABuilt 1978 · S/N 17271240N2335FGravitte Peter F · Napa, CAS/N 21058535N2335GRegistered aircraftBuilt 1958 · S/N 51635N2335UDolphin Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9997N23360Xc Aviation LLC · Wyckoff, NJBuilt 1968 · S/N 15068901N23364Ephraim Flyers Inc · Ephraim, WIBuilt 1968 · S/N 15068904N23365Del Rossa Erwin R · Sodus, NYBuilt 1968 · S/N 15068905N2336GLogue Elmer S · Derby, KSS/N 51636N2336UWilson Milledge L · Prosperity, SCBuilt 1962 · S/N 17249936N2336VW Tech Consulting Inc · Wilmington, DEFirst renewal noticeBuilt 2007 · S/N 172S10536N2337Boutique Air Inc · Denver, COBuilt 1969 · S/N 337-1102N23370Carruthers John H Jr · Berlin, NHBuilt 1968 · S/N 15068909N23372Dold Stephen E · Foresthill, CABuilt 1968 · S/N 15068911N23374Pannell Lucas J · Midland City, ALBuilt 1968 · S/N 15068913N2337DSurely You Cant Be An LLC · Albuquerque, NMBuilt 1952 · S/N 20489N2337SMoore John A · Ada, MIBuilt 1967 · S/N 337-0637N23382Galster Scott · Oneonta, NYBuilt 1968 · S/N 15068918N23383Performance Auto Body Inc · Knightdale, NCBuilt 1998 · S/N 18280406N23386Perta Steven J · Rome, NYBuilt 1968 · S/N 15068920N23387Strickland Kim A · Bowling Green, OHBuilt 1968 · S/N 15068921N2338FDonnell James C · Crowville, LABuilt 1964 · S/N 21058538N2338GIberlin Ranch · Gillette, WYBuilt 1958 · S/N 51638N2338VLima 001 LLC · Muscatine, IABuilt 2007 · S/N 172S10538N2338WChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280698N23390Smp LLC · Kenner, LAS/N 15068924N23391Porter Scott · Aguila, AZBuilt 1968 · S/N 15068925N23392Mullins Adrian · Cartersville, GABuilt 1968 · S/N 15068926N23398Murillo Anthony · Davis, CABuilt 1968 · S/N 15068928N2339CSullivan Nathan · Croton, OHS/N 30639N2339DWenrich Kevin P · Myerstown, PAS/N 20491N2339GWetzel William W · Carrizozo, NMBuilt 1958 · S/N 51639N2339RStephens Grant A · Palmer, AKBuilt 1964 · S/N 18255439N2339XPetet David G · Orofino, IDBuilt 1965 · S/N 18256239N2339YGross Barbara J · Timber Lake, SDS/N 17700139N233AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2004 · S/N 172S9770N233CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12336N233DCMc Aviation Holdings LLC · Miami, FLBuilt 1998 · S/N 18280289N233EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13096N233FFArq Aviation LLC · Wilmington, NCBuilt 2026 · S/N 172S13573N233GSGreenville County Sheriffs Office · Greenville, SCBuilt 1972 · S/N 18261018N233KSJean Buford Randall · Lorena, TXBuilt 1998 · S/N 18280145N233MEEight Ball Flying Club · Van Nuys, CABuilt 2000 · S/N 18280750N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920N233WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 18257879N233WRVenture Alaska LLC · Homer, AKS/N U20603574N23407S C Skylane LLC · Cumming, GABuilt 1998 · S/N 18280409N2340GConner Chris L · Boise, IDS/N 51640
Back to AD 79-10-14 R1