OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N7050QMindy Limited LLC · Muscatine, IABuilt 1972 · S/N 17260350N7051State Of Alaska · Anchorage, AKBuilt 1953 · S/N 18-2932N7051GWein Greggory J · Convoy, OHBuilt 1969 · S/N 17258751N7051QBright Flight Aviation Inc · Jacksonville, FLBuilt 1972 · S/N 17260351N7051RBest Equipment Leasing LLC · Bakersfield, CABuilt 1966 · S/N 28-21749N7052State Of Alaska · Anchorage, AKBuilt 1968 · S/N 18-8729N7052FStephens Racquel C · Laguna Niguel, CABuilt 1976 · S/N 28-7790179N7052GG&H Aviation · Louisville, KYBuilt 1969 · S/N 17258752N7052QHoloman T Michael · New Smyrna Beach, FLBuilt 1972 · S/N 17260352N7052RSell Carl N · Spanaway, WABuilt 1966 · S/N 28-21750N7052WPuskala Thomas S · Iron River, MIBuilt 1962 · S/N 28-817N7053Jsrs Holdings LLC · Las Cruces, NMBuilt 1968 · S/N 18-8730N7053BStevens Alan · Meridian, IDBuilt 1956 · S/N 22-4307N7053GSpare Change Enterprises LLC · Atlantic, IABuilt 1969 · S/N 17258753N7053LVelvick Kathleen R · Peoria, AZBuilt 1989 · S/N WJ-1N7053QCabrie Aviation Inc · Charlotte, NCBuilt 1972 · S/N 17260353N7053WRed Rock Flying School LLC · Mesa, AZBuilt 1962 · S/N 28-805N7054State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8915N70541Cl Finney Aviation LLC · Benton, KSBuilt 1969 · S/N 17258757N7054BWinter Jerry L · Cumming, GAS/N 22-4310N7054WLanguage Gert Johannes · Hays, KSS/N 28-820N7055State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8916N7055QSeagraves Brad J · Rockwell, NCBuilt 1972 · S/N 17260355N7055RRegistered aircraftBuilt 1966 · S/N 28-21754N7055WRickard Donald L · Rowland Hts, CABuilt 1962 · S/N 28-823N7056State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8917N70562Jets To Helis LLC DBA · Chandler, AZBuilt 2001 · S/N 3281N7056QFleeman Joseph R · Lawrenceburg, TNBuilt 1972 · S/N 17260356N7056WEustace Daryl R · Scottsboro, ALBuilt 1962 · S/N 28-824N7057QMindy Limited LLC · Muscatine, IAS/N 17260357N7057RContreras Robert G · Norman, OKBuilt 1966 · S/N 28-21756N7057WWatkins Travis · Haughton, LABuilt 1962 · S/N 28-829N7058GDc Aerial Photos Inc · Fredericksburg, VABuilt 1969 · S/N 17258758N7058RMoss Harold E II · Overland, MOBuilt 1966 · S/N 28-21757N7058WRoman Donald M Jr · New Middletown, OHBuilt 1962 · S/N 28-810N7059State Of Alaska Department Of Public Safety · Anchorage, AKBuilt 1963 · S/N 18-8043N70597Rodriguez Hulises · Chula Vista, CABuilt 1976 · S/N 17267223N7059DSmith Andrew W · Willow, AKBuilt 1957 · S/N 22-4956N7059GFrank Todd E · Corsicana, TXBuilt 1969 · S/N 17258759N7059HFly In Helicopters LLC · Florence, SCS/N 3695N7059PProx Jonathan P · Enterprise, ALBuilt 1960 · S/N 24-2209N7059SParker Helicopter LLC · Watsonville, CABuilt 1999 · S/N 2904N7059WMartin Gerard A · Boston, KYBuilt 1962 · S/N 28-811N705ABHart Aviation LLC · Emory, TXBuilt 2000 · S/N 2099N705CFStanbridge Dale · Phoenix, AZBuilt 1979 · S/N 28-7916339N705FLSue Christina Alicia · San Antonio, TXBuilt 1972 · S/N 28-7225290N705MMLeon Marco M · Broadlands, VABuilt 1978 · S/N 28-7816648N705NRState Of Minnesota · Grand Rapids, MNBuilt 2000 · S/N 415-2000N705PKahre Ryan · Blaine, WAS/N 28017CN705SRNewell Ryan A · Canton, OHBuilt 2020 · S/N 956
Back to AD 79-10-03 R2