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.

N33763Elon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28-7515361N33764Ps Aviation Inc · Granada, MNBuilt 1975 · S/N 28-7505178N3376XVanmeter Investments LLC · Tecumseh, OKBuilt 1966 · S/N 3380N33772Land Of Lincoln Flying Club Inc · Mattoon, ILBuilt 1975 · S/N 28-7505180N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337N3377ZMorris David S · North Pole, AKBuilt 1960 · S/N 18-7258N3378EVisalia Flyers LLC · Visalia, CABuilt 1978 · S/N 17271524N33793Schwartz Robert E · Middleburg, FLBuilt 1975 · S/N 28-7515363N337CACendejas Christian · Montclair, CABuilt 1979 · S/N 17272213N337EPAtp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995064N337FBMa Aviation Group LLC · Farmingdale, NYBuilt 2003 · S/N 2843550N337GFLewis John P · Alachua, FLBuilt 1969 · S/N 17258349N337HCustom Aircraft Inc · Palmer, AKBuilt 1999 · S/N 2999N337HRRahlf Steven · Muscatine, IAS/N 3N337JMJstol LLC · Monrovia, INBuilt 2022 · S/N CCK-1865-1107N337RARogers Kenneth R · Sandusky, OHBuilt 1978 · S/N 3099N337SBA1b LLC · Hinsdale, MTBuilt 2000 · S/N 2052N338Plane Fun Inc Tr Trustee · Snellville, GABuilt 1993 · S/N 2141N33802Drew Mark David · Phoenix, AZBuilt 1975 · S/N 28-7515364N33803Mclellan Simon W · Monroe, WABuilt 1975 · S/N 28-7505182N33806Eagle 64 LLC · Stuart, FLBuilt 1975 · S/N 28-7515365N3380KKabat Jules Max · Las Vegas, NVBuilt 1946 · S/N 1373N3380MSkaggs Jay D · Eagle River, AKBuilt 1947 · S/N 12-2227N3380XGretencord Howard F Trustee · Kansas City, MOBuilt 1966 · S/N 3381N3380ZSchwend Brian · Forsyth, MTBuilt 1960 · S/N 18-7261N3381XBagwell Trevor T · Valencia, CABuilt 1966 · S/N 3382N33836Patton Daniel E · Thornton, PABuilt 1975 · S/N 28-7505186N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683N3383ZMcghee Johnny A · Louisburg, NCBuilt 1960 · S/N 18-7267N33847Registered aircraftBuilt 1975 · S/N 28-7525249N33848Crymes Robert S · Woodbridge, VABuilt 1975 · S/N 28-7505187N3384ZJones Robert D Jr · Chugiak, AKBuilt 1960 · S/N 18-7268N3385XKelly Paul M · Granite Bay, CABuilt 1966 · S/N 3383N3386ED Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 17271526N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687N3387ZBlake Clark D · Belle Fourche, SDBuilt 1960 · S/N 18-7271N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352N3389ZTorgerson'S LLC · Ethridge, MTBuilt 1960 · S/N 18-7274N338BSMcnabb William B · Kingsport, TNBuilt 2002 · S/N 80310N338CALincoln Skyways Inc · Lincoln, CABuilt 1978 · S/N 17269465N338PMMarso Peter G · Decorah, IABuilt 2019 · S/N KA15081311N338QJones Thomas P · Quartz Hill, CABuilt 1971 · S/N 70N338RVSalvini John M · San Luis Obispo, CABuilt 2004 · S/N 80696N338TRChan John · Newport Coast, CABuilt 2021 · S/N 90108N338VHDevries Larry E · Pella, IABuilt 1993 · S/N 2300N3390TTucker Lon R · East Peoria, ILBuilt 1967 · S/N 17700690N3390XPrince Aviation LLC · Las Vegas, NVS/N 3385
Back to AD 79-10-03 R2