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.

N8198WGreenshields Brett William · Eastvale, CABuilt 1965 · S/N 28-2326N8198ZPlatz Trevor · Pine Grove, CABuilt 1982 · S/N 28-8216146N819BABig Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-866N819DWMarchio Anthony J · Flower Mound, TXBuilt 2004 · S/N 25374N819GHFincher James B · Roanoke, ALBuilt 1999 · S/N 20319N819JBChance Billy M · Normangee, TXS/N 22-6693N819JKHaviland John G · Fenton, MIBuilt 2010 · S/N JK02N819JSZnamenacek Kevin L · Western, NEBuilt 1980 · S/N 28-8190044N819MWPussy Galore Aviation LLC · Kalispell, MTBuilt 2002 · S/N 80964N819TTHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1992 · S/N 2161N819WWMaier Ryan D · Bemidji, MNBuilt 1991 · S/N 273N81BAAscent Aviation Inc · Van Nuys, CABuilt 1974 · S/N 28-7415440N81BJBudahn Christopher W · Kenyon, MNBuilt 1989 · S/N 978N81BSFairchild Donald R · Ringgold, GAS/N 284N81CYKrueger Nicholas P · Somerset, WIBuilt 1982 · S/N 156N81DGRae Seth R · Spotsylvania, VABuilt 1967 · S/N 28-4579N81DHMusser Scott S · Pasco, WABuilt 2000 · S/N 2064N81EMMalone Mark R · League City, TXS/N A-L-1N81FBStack John A · Trenton, SCS/N 007N81JACsukay Orkideh · Reseda, CABuilt 1993 · S/N 1581N81JFMains Donald L · Hiram, MEBuilt 1981 · S/N 81-7N81LLJma Aviation LLC · Lakin, KSBuilt 1959 · S/N 24-1338N81LSPedulla Rich · Wyalusing, PAS/N 22-6770N81MHSvedrovic Alex P · Waterbury, CTBuilt 1968 · S/N 28-24238N81MLLovelace Malcolm E · South Vienna, OHBuilt 2002 · S/N 983N81MXApodaca Alvarez Alan · Los Angeles, CABuilt 2022 · S/N 12N81PMSpinnaker Aviation LLC · Conroe, TXBuilt 1973 · S/N 28-7325314N81RBBogar Blake A · Raymond, WABuilt 1988 · S/N 1212N81RGRemsberg Edwin H · Fallston, MDBuilt 1958 · S/N 1089N81SHSharff Steven T · Georgetown, DEBuilt 1978 · S/N M-2095N81SMSchwartz Grantham L · Garden City, TXBuilt 2005 · S/N 1402-2005N81TDAfmr Inc · Dover, DEBuilt 1981 · S/N 500N81XMNoble Gary D · Sioux Falls, SDBuilt 1964 · S/N 2727N81ZWWiens Zachary S · Portland, ORBuilt 1947 · S/N 12-3085N82005S&H Leasing LLC · Sarasota, FLBuilt 1981 · S/N 28-8116286N82006Marquiss Gary C · Gillette, WYBuilt 1978 · S/N 18-7809125N8200KRoss Lanson C · Labelle, FLS/N GTM4N8200VHills Holding · Newark, DEBuilt 1980 · S/N 28-8016319N8200ZFlack Norma Jeanne · Fort Lauderdale, FLBuilt 1980 · S/N 28-8016320N82016Armstrong John Russell Jr Trustee · Commerce, TXBuilt 1979 · S/N 18-7909052N82017Russell Alex B Jr · Soldotna, AKBuilt 1978 · S/N 18-7809118N8201NLang Peter J · Coopersburg, PAS/N 28-25403N8201W8201w General Partnership · Wilbraham, MAS/N 28-2330N82022Hard Luck Aviation LLC · Tok, AKBuilt 1978 · S/N 18-7809113N8202WN8202w LLC · American Fork, UTBuilt 1965 · S/N 28-2331N82035Troia Andrew · Homer, AKBuilt 1978 · S/N 18-7809115N8203NPope Jimmy M Jr · Eastover, NCBuilt 1969 · S/N 28-25408N8203WCarter Terry A · Clinton, ARBuilt 1965 · S/N 28-2334N82044Chandler Air Service Inc · Chandler, AZBuilt 1982 · S/N 28-8216156N82048Newton Property Leasing LLC · Greene, IABuilt 1982 · S/N 28-8290127
Back to AD 79-10-03 R2