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.

N2357LLords Assets LLC · Columbus, OHBuilt 1963 · S/N M-195N2357ZUsda Aphis Ws Atoc · Cedar City, UTBuilt 1980 · S/N 18-8109016N2358LSimpson Timothy A · Niles, MIBuilt 1963 · S/N M-196N2358QBertrand Jason A · Seattle, WAS/N M-427N2358ZBrinegar Matthew D · North Tustin, CABuilt 1962 · S/N M-70N2359PRyan Good Aviation LLC · Sioux Falls, SDBuilt 1955 · S/N 18-4245N2359QBean Glen A · Damascus, ORS/N M-428N2359TChopco Ltd · Columbus, OHS/N 2359N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159N235LHMaupin Dean C · Davenport, IABuilt 2001 · S/N 80844N235PAGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 28-7816678N235RCNewberry Guy · Port Byron, ILBuilt 1990 · S/N LA 215N235SRDraco Flight School DBA · Chino, CABuilt 2003 · S/N 2842182N235TPSvl Aviation LLC · Delray Beach, FLBuilt 1985 · S/N 28-8516036N2360RLamarra Anthony A · Clarkston, MIBuilt 1969 · S/N 28-5496N2361LUnderwood Richard R · Armuchee, GABuilt 1963 · S/N M-190N2361QLong Lawrence R · South Whitley, INS/N 28-7716100N2361RVenture West LLC · Mesa, AZBuilt 1969 · S/N 28-5497N2361ZBoyles Michael K · Waynesboro, MSBuilt 1962 · S/N M-73N2362HCarpenter Forrest A · Longmont, COBuilt 1979 · S/N 18-7909177N2362LWatkins William V · Porter, OKBuilt 1963 · S/N M-176N2362QStiers Randell E · Bunker Hill, INBuilt 1963 · S/N M-435N2362ZFlowers Jesse S · Moscow, IDBuilt 1962 · S/N M-76N2363YPlane Pro Aviation LLC · Shelby, NCBuilt 1967 · S/N 17700163N2363ZBlack Thomas L · Springtown, TXBuilt 1962 · S/N M-77N2364JSwenson Roger A · Pahrump, NVBuilt 1963 · S/N M-322N2364MKissenger Richard G · Centre Hall, PABuilt 1946 · S/N 12-1611N2364PDesert Flyers Inc · Mc Neal, AZBuilt 1955 · S/N 18-4251N2364TVintage Aero Club · Smoketown, PABuilt 1971 · S/N 28-7225055N2365LPrue Paul E · Golden, COBuilt 1963 · S/N M-201N2365QGonzalez Lazaro · Springfield, NJS/N M-439N23660Amblin Antique Air Inc · Green Cove Springs, FLBuilt 2000 · S/N 24433N2366JPhillips Michael L · Mays Landing, NJS/N M-324N2366WAir-Mods Flight Academy · Robbinsville, NJS/N 28-8516046N2366ZAerotyne International LLC · Prattville, ALBuilt 1962 · S/N M-87N2368PAerial Messages Leasing Co · Longwood, FLBuilt 1955 · S/N 18-4257N2368QWagner Steve · Prescott, AZBuilt 1963 · S/N M-448N2368ZJpk Aviation LLC · Bowling Green, KYBuilt 1962 · S/N M-89N2369JSchemenauer Phillip · Bristol, INFirst renewal noticeBuilt 1963 · S/N M-327N2369YMischel John Patrick · Salyersville, KYBuilt 1967 · S/N 17700169N236AFAero Fisheries Inc · Fort Pierce, FLBuilt 1976 · S/N 17267726N236JTempleton James N · Petersburg, ILBuilt 1977 · S/N 1122N236PAGreene James · Hudson, SDBuilt 1978 · S/N 28-7816679N236RATechnical Education Services Inc · Virginia Beach, VABuilt 1994 · S/N 2236N236RVHunt Timothy C · Greenville, TXBuilt 2003 · S/N 22467N236ZKMaximum Ceiling Aviation LLC · Farmingdale, NYS/N 2843401N2370HMoeller David A · Anchorage, AKBuilt 1979 · S/N 18-7909178N2370QBrandt James R · Caro, MIBuilt 1963 · S/N M-443N2371ETmc Shooting Range Specialist Inc · Valencia, CAS/N 17271254N2371PZmirly Aviv · San Diego, CABuilt 1955 · S/N 22-2762
Back to AD 80-04-03 R2