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.

N8499LKennedy Christopher S · Canton, ILBuilt 1968 · S/N 17256699N8499RZoss Curtis · Pensacola, FLBuilt 1966 · S/N 28-22411N8499WNazif Ziad J · Denver, NCBuilt 1965 · S/N 28-2747N84CBRegistration Pending · Buda, TXRegistration pendingBuilt 1971 · S/N SA300N84DLAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1979 · S/N 17272771N84DWBuffalo Valley Aviation LLC · Neosho, MOBuilt 1973 · S/N AA5-0308N84GSAjluni Robert · Shreveport, LABuilt 1975 · S/N AA5A-0071N84HWBerkbiegler Allen · Hardy, ARS/N 385N84HYH&A Aviation Lc · Hanover, VABuilt 2002 · S/N 2184N84KGGinz Peter M · Guilford, CTS/N 8047CN84KTTaylor Kevin G · Mountain Grove, MOBuilt 2011 · S/N 82291N84LLLiebsch Mark · Reno, NVBuilt 1984 · S/N 995N84LPMinuteman Air Service Inc · Dewitt, ARBuilt 2003 · S/N 25643N84NSale Reported · Eagle Point, ORSale reportedBuilt 1998 · S/N 1N84PTTackabury Jenny Ann · Santa Paula, CABuilt 1985 · S/N 1N84RLStockman Harold O · Elko, NVBuilt 1996 · S/N 84N84RMAugust Aero LLC · Kalispell, MTS/N 115N84RPWellborn Michael Barrett · Broken Arrow, OKBuilt 1998 · S/N 20849N84SAAshley Heating & Air · Wasilla, AKS/N 81576N84SFFifield Scott D · Overgaard, AZBuilt 2008 · S/N 5334N84SKQuinlan John H · Claxton, GABuilt 1989 · S/N SN-554N84TKRegistered aircraftBuilt 2007 · S/N 21432N84WMErickson Lee A Trustee · Fargo, NDBuilt 1994 · S/N 1264N84ZRomeo Aviation Ltd · East Sparta, OHBuilt 1959 · S/N TD-232N85007Sidell Joel R · Brighton, COBuilt 2010 · S/N 2000N8500DScootair LLC · Alburgh, VTBuilt 1957 · S/N 22-5727N8501DStrausser Brian J · Lower Burrell, PABuilt 1957 · S/N 22-5728N8502DConrad Dylan · Randolph, WIBuilt 1957 · S/N 22-5729N8503EB&B Aviation Holdings LLC · Pembroke Pines, FLBuilt 1976 · S/N 28-7690175N8505DRegistration Pending · Wilmington, DERegistration pendingBuilt 1957 · S/N 22-5732N8507DFischer Duane A · New Baden, ILBuilt 1957 · S/N 22-5734N8508DHuhndorf Joshua L · Port Ludlow, WABuilt 1957 · S/N 22-5735N8509DVeal Petra I · Sterling, AKBuilt 1957 · S/N 22-5736N8510DShipley Steven D · Masterson, TXBuilt 1957 · S/N 22-5737N8511FMrd Aero LLC · Manheim, PABuilt 1976 · S/N 28-7725119N8513DRowland Nathan A · Lascassas, TNBuilt 1957 · S/N 22-5740N8514DBecker Gloria J Personal Representative · Gladwin, MIBuilt 1957 · S/N 22-5741N8514YMcnally Rodney · Sonora, CABuilt 1967 · S/N 30-1675N8516DBass Edward L · San Angelo, TXBuilt 1957 · S/N 22-5743N8516FFarley Gail A · Elizabethtown, PABuilt 1976 · S/N 28-7715276N8517KBeadle Scott · Fort Worth, TXBuilt 1983 · S/N 1N8518CBoesl Shawn W · Aberdeen, SDBuilt 1953 · S/N 20-993N8518DWood Michael · Port Saint Lucie, FLBuilt 1957 · S/N 22-5745N8518WEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1984 · S/N 0425N8519YAerial Sign North Inc · Lakewood, NJBuilt 1970 · S/N 18-8885N851DFFoster Gregory S · Woodstock, GABuilt 1975 · S/N AA5B-0149N851LW578 Airplane Leasing Inc · Kissimmee, FLBuilt 1968 · S/N 17257189N851NDSkymates Inc · Wilmington, DEBuilt 1989 · S/N 4495005N851WTFowler Clinton Lewis · Conroe, TXBuilt 1976 · S/N 28-7790077N8521YVan Devere Joseph C · Akron, OHBuilt 1970 · S/N 18-8886
Back to AD 80-04-03 R2