OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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:80-04-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:80-04-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.

N41265Sunrise Aviation Y1n LLC · Albert Lea, MNBuilt 1974 · S/N 28-7405087N41267Faulkner Terry · Dixon, CAS/N 28-7415151N4126JRogers Barclay L · Martinsburg, WVBuilt 1966 · S/N 28-22445N4126PPorebski Peter T · New Port Richey, FLBuilt 1975 · S/N 17702320N4126XTreat Michael F · Webster, WIBuilt 1968 · S/N 225N41271Paris Keely Owen · Ottumwa, IABuilt 1974 · S/N 28-7405088N4127ALiquid Metal LLC · Wilmington, DEBuilt 1998 · S/N 2843148N4127JVan Aero LLC · Dover, DEBuilt 1966 · S/N 28-22446N4127ZMamrol Peter J · Anchorage, AKBuilt 1964 · S/N 18-8196N41287Preneta Andrew T · Oxford, CTBuilt 1974 · S/N 28-7415159N4128ZPierskalla Veronica Y · Wasilla, AKBuilt 1964 · S/N 18-8197N41290Hilton Head Flyers LLC · Liberty, SCBuilt 1974 · S/N 28-7415161N41291N41291 LLC · Fort Worth, TXBuilt 1974 · S/N 28-7415162N41293Wauchula Aero Club Inc · Wauchula, FLS/N 28-7405090N4129DBoyd Edward Lee · Apison, TNBuilt 1998 · S/N 2843174N4129EBlase Benjamin J · Seeley Lake, MTBuilt 1978 · S/N 18-7809081N4129RD&J Aviation LLC · Apopka, FLBuilt 1998 · S/N 2843159N4129XHaines Robert E · Yukon, OKBuilt 1968 · S/N 229N4129ZWild About Nature LLC · Fairbanks, AKBuilt 1965 · S/N 18-8199N412BNBythrow Peter F · Columbia, MDBuilt 2003 · S/N 60400N412DMMead Ronald C · Wichita, KSBuilt 1985 · S/N 412N412FXCougar Aircraft Corp · Cheyenne, WYBuilt 1978 · S/N GA70035N412HMCain Ryan C · Beaumont, CABuilt 1975 · S/N 20-1163N412LClark Terry E · Dixon, MOBuilt 1954 · S/N 23-18N412MRMundy Mark · Cape Coral, FLBuilt 1968 · S/N 680163N412PCHelmen Harry W · Ruckersville, VABuilt 1956 · S/N 22-4311N412SCMay Bob L · Wedowee, ALBuilt 1946 · S/N 12-868N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310N4130JOur Space Properties LLC · Camdenton, MOBuilt 1966 · S/N 28-22451N4130PKoch William L · Barre, VTBuilt 1959 · S/N 23-1610N41316Elliott Barry E · Lake Havasu City, AZBuilt 1974 · S/N 28-7415168N41318Bailey Jeffrey R · Indianapolis, INBuilt 1974 · S/N 28-7415169N4131JTomb Randall H Jr · Pittsburgh, PAFirst renewal noticeBuilt 1966 · S/N 28-22453N4131UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843199N4131XElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1968 · S/N 230N4131ZMacarthur Clinton W · Anchorage, AKBuilt 1965 · S/N 18-8201N41320Dutchyshyn Harry V Jr · Pasadena, MDBuilt 1974 · S/N 28-7405092N41327Sharp Penny E · Ocala, FLBuilt 1974 · S/N 28-7415171N4132YMartin Beaux R · Calhoun, LAS/N 234-76N4133EHouse Larry A · Anchorage, AKBuilt 1978 · S/N 18-7809129N4133PCoulson Michael D · Zanesville, OHBuilt 1959 · S/N 23-1613N4133XAnfuso Keith · La Habra Heights, CAS/N 232N41342Papoutsis Thomas J · Chambersburg, PAS/N 28-7405094N41348Low George D · Newport, MIBuilt 1974 · S/N 28-7425227N41349Minot Aero Center · Minot, NDBuilt 1974 · S/N 28-7415179N4134JPriebe Aviation LLC · Waseca, MNBuilt 1966 · S/N 28-22456N4134ZHuseby Terry L · Hulett, WYBuilt 1964 · S/N 18-8207N41357Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7425228N41359Ayubi-Moak Jason S · Chandler, AZBuilt 1974 · S/N 28-7415184
Back to AD 80-04-03 R2