OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N3200MPride Jesse D · Eagle River, AKS/N 12-1872N3200ZBrady Michael E · Buffalo, NYBuilt 1959 · S/N 22-7140N32019Spicher Samuel Charles · Harrisonburg, VABuilt 1974 · S/N 28-7505017N3201ZMcclain William J · Corona, CABuilt 1959 · S/N 22-7141N3202SCramer Traci · Hatfield, PABuilt 1996 · S/N 1111SN32030Robert Starr · Schofield, WIBuilt 1974 · S/N 28-7515048N3203FChampagne Anthony J · Prairieville, LABuilt 1967 · S/N 670123N32042Van Anda Aviation LLC · Apopka, FLBuilt 1974 · S/N 28-7515052N32043Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7515053N32052Risley Bryan D · Bartow, FLBuilt 1974 · S/N 28-7525016N32056Steuer Christopher · Plumas Lake, CABuilt 1974 · S/N 28-7515056N32059Coast Property Inc · Nipomo, CABuilt 1974 · S/N 28-7505021N3205JSchumacher Eraine · Hague, NDBuilt 1958 · S/N 1238N32066Chadwick Cobb Kristy L · Tallahassee, FLBuilt 1974 · S/N 28-7515059N32067Legeros David · Brooklyn, NYS/N 28-7515060N32069Adb Investments LLC · Duncan, SCBuilt 1974 · S/N 28-7515062N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467N32070Williams Seth M · Jeanerette, LAFirst renewal noticeS/N 28-7505022N3207PTraverse Air Inc · Traverse City, MIBuilt 1957 · S/N 23-1147N320827550g LLC · Birmingham, MIBuilt 1974 · S/N 28-7515065N32095Rogers Dekishon W B · Atlanta, GABuilt 1974 · S/N 28-7525021N32097Seniram Air Inc · Wilmington, DEBuilt 1975 · S/N 28-7515067N32099Odland Steve E · Luverne, MNBuilt 1974 · S/N 28-7515068N3209PMg Renewal Corp Inc · Salt Lake City, UTFirst renewal noticeBuilt 1957 · S/N 23-1150N320AGBusenbark Kenneth A · Niceville, FLBuilt 1991 · S/N 37032012614P2N320AKMclauchlin Todd · Sparks, NVBuilt 2001 · S/N 3841N320CLSantiago Carlos M · Davis Junction, ILBuilt 2013 · S/N 002N320DDBronson Robert D Trustee · Prineville, ORBuilt 1972 · S/N 17261193N320DJRegistration Pending · Beaufort, SCRegistration pendingS/N 249-320-17N320DPParr David A · Murray, UTS/N 707-320-551N320DTCarroll Michael · Twinsburg, OHBuilt 2004 · S/N 20144N320EDOday Shane C · Rose Hill, KSS/N 1288N320ESBristol Peter W Sr · Punta Gorda, FLBuilt 2000 · S/N 859320701N320JAMalsack Joseph A · Merrill, WIS/N 292-320-54N320JGRegistered aircraftBuilt 1990 · S/N 133N320JHNewby Jeremy B · Fruitland, IDBuilt 1990 · S/N 349N320JSDouma Todd D · Salome, AZBuilt 2014 · S/N 102MN320LEBalkin John Sergei · Bigfork, MTS/N 332N320MBBeyer Neal K · Manitowoc, WIBuilt 1996 · S/N 017N320MMExplorer Aviation LLC · Birmingham, MIBuilt 1997 · S/N 1231-97N320MTKeeling Larry · Sun Lakes, AZFirst renewal noticeBuilt 1999 · S/N 2804N320MVJonsson Erik · Twin Falls, IDS/N 0032N320MWTriple Nickel Aviation LLC · Fort Lauderdale, FLBuilt 1995 · S/N 189N320PLCavitt Peter G · San Diego, CABuilt 1997 · S/N 001N320RVVan Dyke Stewart D · Carmel, INBuilt 1999 · S/N 24652N320SHMoore Michael C · Anchorage, AKBuilt 1956 · S/N 185060N320SLHelmuth Jesse N · Willow, AKS/N 03206N320THN63e LLC · Fallon, NVBuilt 1996 · S/N 225N320WWatson R Samuel · Hartsville, SCBuilt 1996 · S/N 1001AN320ZPrzestrzelski John M · Frankfort, NYBuilt 2021 · S/N 11000
Back to AD 79-10-03 R2