OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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.

N74735Tipton Michael · Florissant, COBuilt 1961 · S/N 1735N74736Russell Robert C · Decatur, ALBuilt 1961 · S/N 1736N7473DRezzonico John · Round Hill, VABuilt 1957 · S/N 18-5808N7473RSonntag Donald · Marengo, ILFirst renewal noticeBuilt 1966 · S/N 28-22022N74740Woodyatt Michael A · Byron, ILBuilt 1976 · S/N AA5B0358N74745Renfroe Daniel P · Eagleville, TNBuilt 1961 · S/N 1745N74747Dubois Alan P · Jamestown, RIBuilt 1961 · S/N 1747N74748Moore David · Amarillo, TXBuilt 1961 · S/N 1748N7474DRogue Aero LLC · Grants Pass, ORS/N 18-5809N7474GBarnett Kevin · Simi Valley, CABuilt 1970 · S/N 17259174N7474LNelson Travis E · Richland, MTBuilt 1975 · S/N 18-7509069N7474RGregorski Thomas E · Kenly, NCBuilt 1966 · S/N 28-22023N7474TWorks James K · Avalon, CABuilt 1967 · S/N 28-23432N7474WZimmerman Sandra · Henderson, NVBuilt 1963 · S/N 28-1379N74750Anderson Jonathan R · Corpus Christi, TXS/N 1750N74752Brundige Mark S · Mount Pleasant, TXBuilt 1961 · S/N 1752N74758Robins Stephen B · Hutchinson Island, FLS/N 1758N74759Page Casey P · Abilene, TXBuilt 1961 · S/N 1759N7475RTolsma Garrett J · Kirkland, WABuilt 1966 · S/N 28-22024N74760Boyle Fred Sr · Cape May, NJBuilt 1961 · S/N 1760N74762Bulldog Aviation LLC · Kalispell, MTBuilt 1961 · S/N 1762N74763Crouse Stanley G · Greenwood, MOS/N 1763N74764Carter Dejuan Jermaine · Little Rock, ARBuilt 1961 · S/N 1764N74765Lister Thomas L · Wynnewood, OKS/N 1765N74766Reiner Henry A · Hutchinson, MNBuilt 1961 · S/N 1766N74768Delissa Leighton A · Meade, KSS/N 1805N74769Bulut LLC · Los Angeles, CAS/N 1769N7476LGrabofsky Livestock & Grain Inc · Hogeland, MTBuilt 1975 · S/N 18-7509072N7476RCarrillo Jeremiah · Shelton, WABuilt 1966 · S/N 28-22026N7476WAddison Robert M · Fort Sumner, NMBuilt 1963 · S/N 28-1385N7477Lochinger Dale · Everson, PABuilt 2020 · S/N 22205N74770Dubois Aviation Inc · Chino, CABuilt 1961 · S/N 1770N74774Alyeska Helicopters LLC · Girdwood, AKBuilt 2005 · S/N 3967N74775Morriss Robert W · Amarillo, TXS/N 1775N74777N74777 LLC · Key West, FLBuilt 1961 · S/N 1777N7477LWika Gregory B · Anchorage, AKS/N 18-7509060N7477RRegistration Pending · Richmond Hill, GARegistration pendingS/N 28-22028N7477WBechaver Landon Robert · Mesa, AZBuilt 1963 · S/N 28-1387N74781Steed Charles · Apple Valley, UTBuilt 1961 · S/N 1902N74783Clarida James · Marion, ILBuilt 1961 · S/N 1783N74785Jette Scott · Santa Clarita, CAS/N 1785N7478GMckinney Brian M · Lakeville, MNS/N 17259178N7478LAmidon Gary S · Shady Cove, ORBuilt 1975 · S/N 18-7509073N7478MMayle Brian · West Granby, CTBuilt 1958 · S/N 55778N7478WTaylor Randall Devlin Trustee · Austin, TXBuilt 1963 · S/N 28-1388N74793Cabell Jeffrey Paul · Boca Raton, FLS/N 1793N74795Jones Jeffery A · Grand Forks, NDBuilt 1961 · S/N 1795N74796Kuiper Steven J · Sahuarita, AZBuilt 1961 · S/N 1796N74797Stevens Kerry · Beaverton, ORS/N 1797N74798Rodriguez Alex · Apopka, FLS/N 1798
Back to AD 80-04-03 R2