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.

N2459CAkchak Air LLC · Leeds, UTS/N 30759N2459DShaw Brian W · Bemidji, MNS/N 20611N2459LMedia Stew LLC · Carson City, NVBuilt 1966 · S/N 17255659N2459MAviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S10035N2459RGardiner Timothy M · Gardendale, ALBuilt 1964 · S/N 18255559N2459SEdb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S10036N2459UHaynes Harrison F · Gainesville, GABuilt 1963 · S/N 17250059N2459VUniversity Of Maine System · Augusta, MEFirst renewal noticeBuilt 2005 · S/N 172S10038N2459YNew Horizon Aviation Inc · Warwick, RIBuilt 2000 · S/N 17280909N245AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13226N245CSTextron Aviation Inc · Wichita, KSS/N 18282423N245EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13284N245FRChupito Sabrocito LLC · Paso Robles, CABuilt 1977 · S/N 17269686N245MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20608240N2460AAmerican Aviation Inc · Brooksville, FLBuilt 2000 · S/N 17280932N2460FRead Colin L · Plattsburgh, NYBuilt 1966 · S/N 18051662N2460GVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N 18281957N2460JSmith Harry N · Glendale, AZBuilt 1966 · S/N 15065560N2460XHardy Gareld L · Rimrock, AZS/N 18256360N24612Iasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280827N24613Ameriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 17280829N24616N24616 LLC · Manassas, VABuilt 1999 · S/N 17280830N24619Atp Aircraft 2 LLC · Wilmington, DEBuilt 2000 · S/N 17280831N2461DWinged Vision Inc · Gaithersburg, MDBuilt 2007 · S/N 20608295N2461EWadekamper Leo · Helena, MTBuilt 2000 · S/N 18280805N2461GSeven Hi Flying Club · Saratoga, CABuilt 1959 · S/N 51761N2461JWeidemann Wendell S · Madison, WIBuilt 1966 · S/N 15065561N2461PMaxxum Financial Group Inc · Destrehan, LABuilt 2005 · S/N 172S10044N2461RFx Mining LLC · Haines, AKBuilt 1964 · S/N 18255561N2461UHansen Aviation LLC · Savannah, GABuilt 1963 · S/N 17250061N2461XBallard Devin J · Quail, TXBuilt 1965 · S/N 18256361N2461YIbx Living LLC · Wake Forest, NCBuilt 1962 · S/N 17249761N2462EFive Six Zero One LLC · Orange, CABuilt 1978 · S/N 17271291N2462GWinged Vision Inc · Gaithersburg, MDBuilt 2007 · S/N 20608296N2462JBercaw Vaughn L · Beach City, TXBuilt 1966 · S/N 15065562N2462LSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 17255662N2462PSan Diego Aviation LLC · San Diego, CABuilt 2005 · S/N 18281733N2462SLyon Joseph K · Mccall, IDBuilt 1967 · S/N 337-0762N2462TEagle East Aviation Inc · North Andover, MABuilt 2000 · S/N 17280834N2462UBixler Timothy · Wildwood, FLS/N 17250062N2462XCattin David · Sarasota, FLS/N 18280791N2463BMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2005 · S/N 18281735N2463CWofford Johnny A · Fort Davis, TXBuilt 1963 · S/N 17250569N2463JTony Noyes · Lewisville, TXS/N 15065563N2463SNjnj Aviation LLC · Belmont, CABuilt 2005 · S/N 18281738N2463ULively Matt E · Aledo, TXBuilt 1963 · S/N 17250063N2463YCaylin LLC · Wilmington, DEBuilt 1962 · S/N 17249763N2464DAero Equities LLC · Ventura, CABuilt 2005 · S/N 172S10046N2464HSo Cal Leasing LLC · El Cajon, CABuilt 2005 · S/N 172S10049N2464RStoffers William · Samoa, CABuilt 1964 · S/N 18255564
Back to AD 79-10-14 R1