OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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-03-R2')
    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-03-R2')
  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.

N7894VHydock David B · Leslie, ARBuilt 1965 · S/N 2937N7894WWiley Thomas W · Anchorage, AKBuilt 1964 · S/N 28-1921N78953Holman Richard S · Clearmont, MOBuilt 1961 · S/N 1987N78955Stuber Paul A · Kansas City, MOBuilt 1961 · S/N 1989N78956Pauly Traviston · Natrona Heights, PABuilt 1961 · S/N 1990N78959Nelson Brian · Pennsburg, PABuilt 1961 · S/N 1993N78960Lydon Ethan J · Lumberton, NJBuilt 1961 · S/N 1994N78961Schuster Christopher J · Sherman, TXBuilt 1961 · S/N 1995N78962Smith Eric A · Kelso, WAS/N 1996N78965Clore Gregory N · Ashland City, TNBuilt 1961 · S/N 1999N78968Harris Rex D · Mason City, IABuilt 1962 · S/N 2142N7896DJohnson Rickie G · Callahan, FLBuilt 1957 · S/N 22-5522N78972Quimby Dean Kelly · Lino Lakes, MNS/N 2006N78975Johnson William P · Shreveport, LABuilt 1962 · S/N 2009N78978Martin Gary P · Boonville, MOBuilt 1968 · S/N 17257796N7897WDimario Carmen · Wilmington, DEBuilt 1964 · S/N 28-1925N78982Douglass William W III · Panora, IABuilt 1962 · S/N 2016N78983Richard Kroll A Law Corp · Laguna Niguel, CABuilt 1962 · S/N 2017N78984Goodin Charles R Jr · Chillicothe, OHBuilt 1962 · S/N 2018N78987Sale Reported · Chickaloon, AKSale reportedBuilt 1962 · S/N 2021N7898GMccutcheon Frank Jr · Scottsboro, ALBuilt 1970 · S/N 17259598N7898VBrown Dallas D · Taylors Falls, MNBuilt 1964 · S/N 2860N78996Dodge Donald V · Newnan, GAS/N 2030N78997Frederick Daniel S · Broad Brook, CTBuilt 1962 · S/N 2031N78998Van Engen Ronald J Jr · Granbury, TXBuilt 1962 · S/N 2032N7899DBlake Richard E Jr · Marion, LABuilt 1958 · S/N 22-5819N7899WAmmon Sol · Papaaloa, HIS/N 28-1928N789AWWalker Alan B · Sunnyside, WABuilt 2011 · S/N 91804N789BNelson Brett R · Shoreview, MNBuilt 1977 · S/N 18-7709171N789BMMcanelly Gary Alan · Burnet, TXBuilt 2002 · S/N 001N789BNDanbom Jimmy D · Tavares, FLBuilt 2004 · S/N 90727N789BRDelong David P · Kirkland, WABuilt 2003 · S/N 90505N789CEBond Brent L · Clearwater, KSBuilt 1978 · S/N 17270536N789DWFergus Falls Aviation LLC · Fergus Falls, MNBuilt 1973 · S/N 28-7325258N789EUnlimited Visibility LLC · Wilmington, DEBuilt 1995 · S/N 3029N789FGSolf William · Winnett, MTBuilt 1970 · S/N 18-8883N789JRMascheroni Andre R · Mccall, IDS/N 28009CN789MHHenderson Michael E · Edmonds, WABuilt 2004 · S/N 5650N789PZarski Rebecca Cross · Sharon Springs, NYBuilt 1972 · S/N 28-7205303N789RAMiller Melanie L · Spanaway, WABuilt 1976 · S/N 17267184N789UTradewinds Aero Inc · Traverse City, MIBuilt 2001 · S/N 23627N78AJHamlin Curits · North Pole, AKBuilt 1978 · S/N 18-7809111N78ATSchrage Rodney L · Steamboat Springs, COBuilt 1985 · S/N 1029N78BGKdrd Holdings LLC · Texas City, TXBuilt 1977 · S/N 28-7890100N78CWPotter Justin D · Eagle River, AKS/N 12-1907N78DFBurkett Robert S · Baytown, TXS/N 1120N78GTBennett Wayne M Jr · Puyallup, WABuilt 1978 · S/N AA5B-0853N78HBValiair Lc Trustee · Casper, WYS/N 2066N78HYD A Lamont Public Adjusters LLC · Springtown, TXBuilt 1999 · S/N 2048N78JMDye William M · Atlanta, GABuilt 1976 · S/N 28-7690430
Back to AD 79-10-03 R2