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.

N6003RRemikin I LLC · Naperville, ILS/N ME-126N6003USoarin Seven Aviation LLC · Morton, ILBuilt 1970 · S/N 28-26809N6003WCarmon Walter A · Highland, NYS/N 28-20003N6003XB&E Leasing LLC · Dubuque, IAS/N 1591N6003YAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-129N6003ZPetranek John A · Mandeville, LAS/N M-2118N6004QSmith Aviation Inc · Wilmington, DEBuilt 1965 · S/N 3224N6004WDorr Martin E · Strongsville, OHBuilt 1978 · S/N M-2121N6005UHaney William R · Pontotoc, MSBuilt 1970 · S/N 28-26906N6005ZMarstall Nancy T · Asheville, NCBuilt 1978 · S/N M-2127N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133N6006WGreen William A · Memphis, TNBuilt 1964 · S/N 28-20006N6007QRegistration Pending · Tampa, FLRegistration pendingBuilt 1965 · S/N 3225N6007USteele Tucker L · The Colony, TXFirst renewal noticeBuilt 1970 · S/N 28-26817N6007WMoore Merritt · Mcarthur, CAS/N 28-20007N6007YAudubon Air Of Louisiana LLC · Bossier City, LABuilt 1978 · S/N M-2130N60083Kocik William J Jr · Shepherdstown, WVBuilt 1978 · S/N M-2083N6008KShore Stephen · Longview, TXBuilt 1981 · S/N M-2086N6008LGawlik Leslie W · Reisterstown, MDBuilt 1978 · S/N M-2087N6009DKirkendall James A · N Richland Hills, TXS/N 22-4661N6009WLowman Jeffrey L · Clarksburg, WVBuilt 1964 · S/N 28-20009N600AABrauer Jason R · Winnebago, ILBuilt 1968 · S/N 28-25102N600AVMountain Top Aviation Inc · Ebensburg, PABuilt 1978 · S/N 28-7916229N600BHBeaupre Harry R · Fallon, NVBuilt 2003 · S/N 2330N600CWWinn Kathy J · Spring, TXBuilt 1994 · S/N 20755N600GGNlh Aviation LLC · College Station, TXBuilt 1980 · S/N 394-80N600HHFleming Mike R · Troy, MOBuilt 1974 · S/N 600N600HJRavotti Air LLC · Leechburg, PABuilt 1978 · S/N 28-7990004N600KKFeielin Kenneth M · Paris, OHBuilt 2007 · S/N 25488N600PFEastern Aviation Corp · Whitestone, NYBuilt 1977 · S/N 28-7816109N600TLLbaviation LLC · Wheatland, WYS/N 1148N600VVMindy Limited LLC · Muscatine, IABuilt 1975 · S/N 17264773N600WPort Of Tillamook Bay · Tillamook, ORS/N 1N60104Theo-N60104 LLC · Wilmington, DEBuilt 1978 · S/N M-2093N60106Lutzko Timothy R · Ocean View, DEBuilt 1978 · S/N M-2094N6010CBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-905N6010DTrenkamp John F · Oskaloosa, IAS/N 22-4662N6010LBergstrom Robert L · Amelia, VABuilt 1972 · S/N AA5-0110N6010PSniffen Kirby K · Sycamore, OHBuilt 1959 · S/N 24-1104N6011LBiondich Amy Sue · Rubicon, WIBuilt 1972 · S/N AA5-0111N6011QHikari Aviation Ltd · Torrance, CABuilt 1978 · S/N ME-100N6011UJin Jin Aviation LLC · Anchorage, AKBuilt 1978 · S/N ME-101N6012LCloudkicker Lc · Sioux Falls, SDBuilt 1972 · S/N AA5-0112N6012YBieszczad Wally · Bloomingdale, ILBuilt 1979 · S/N M-2106N60135Charles Ray Aviation LLC · Fleming Island, FLBuilt 1979 · S/N M-2105N6013DBennett Garrett Douglas · Bonners Ferry, IDBuilt 1956 · S/N 22-4665N6013LCraven Jeremy A · Winter Garden, FLBuilt 1972 · S/N AA5-0113N6013ZVandelay Aviation LLC · San Diego, CABuilt 1978 · S/N ME-112N6014PTwo Men And A Plane Inc · Dearborn, MIBuilt 1959 · S/N 24-1109N6014WLeaders Bob O · Clear Lake, MNBuilt 1964 · S/N 28-20014
Back to AD 79-10-03 R2