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.

N3927ZNordstrom Eric Trustee · Anchorage, AKS/N 18-7755N3928KHanneman Resa L · Denver City, TXBuilt 1967 · S/N 28-23801N3928NVose Richard C · King Of Prussia, PAS/N 680062N3929QMonk Steven M · Lake Tomahawk, WIBuilt 1971 · S/N 17260029N3929ZShaffer Carl E · Fort Bragg, CABuilt 1962 · S/N 18-7776N392CCCecil John P · Willows, CAFirst renewal noticeBuilt 2003 · S/N 9960CCN392ECCompton Edmond · Wytheville, VABuilt 2024 · S/N BH 392 ECN3930KQuick Jeremy R · Bremen, INBuilt 1967 · S/N 28-23803N3930PMatson Dean R · Spring, TXBuilt 1956 · S/N 22-3605N3930RGillett Darrin L · Cedar Falls, IAS/N 28-5848N3930ZDaniel Junior G · Wasilla, AKS/N 18-7777N3931KAlpha 1 Aviation LLC · Helena, ALS/N 28-23804N3932PCuozzo Alfred F · Eagle Point, ORBuilt 1956 · S/N 22-3607N3932QZimmer Jed Michael · Quincy, WAS/N 17260032N3932ZKnefley J Michael · Ulysses, PABuilt 1961 · S/N 18-7756N3933ZRyan Alan Parks · Newcastle, WYBuilt 1962 · S/N 18-7757N3934QChase William R Jr · Enfield, NHBuilt 1971 · S/N 17260034N3934ZWard Gary P · Lincolnton, GABuilt 1962 · S/N 18-7780N3935KKrog Steven L · Hartford, WIBuilt 1967 · S/N 28-23809N3935QBeaufort Flight Training LLC · Beaufort, SCBuilt 1971 · S/N 17260035N3936MAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816386N3936PTroyer Robert E · Toledo, WABuilt 1956 · S/N 22-3611N3937ZBundy Jerrian M · Anchorage, AKBuilt 1962 · S/N 18-7783N3938CHale Phil · Palm Bay, FLBuilt 2008 · S/N 70569N3938KCdb Group Holdings LLC · Sheridan, WYBuilt 1967 · S/N 28-23813N3938NSundance Aviation Inc · Richland, WABuilt 1968 · S/N 680065N3938PSwoboda Matthias W · Green Bay, WIBuilt 1956 · S/N 22-3613N3938QGreen Carl P · Columbia, MSBuilt 1971 · S/N 17260038N3938ZCooper Donald A · Casper, WYBuilt 1962 · S/N 18-7784N3939KRegistration Pending · Grand Prairie, TXRegistration pendingBuilt 1967 · S/N 28-23814N3939RReid Edwin G Jr · Hollywood, MDBuilt 1970 · S/N 28-5850N3939XArapahoe Flight Club LLC · Colorado Springs, COBuilt 1975 · S/N 28-7515434N3939ZCarnine Daniel · Angora, NEBuilt 1962 · S/N 18-7785N393AWRoe Elton L · Harrison, ARBuilt 1968 · S/N 252N393HWilliams Fred V · Reno, NVBuilt 2022 · S/N 58P-111P/112P-P299N393RCBarnes Thomas M · Pittsboro, NCBuilt 2001 · S/N 1176N3940KAir Ventures Flying School LLC · Smithfield, RIBuilt 1967 · S/N 28-23764N3940MCondair Flyers Inc · Latham, NYBuilt 1978 · S/N 28-7816388N3940ZGrasser Edward K · Palmer, AKBuilt 1963 · S/N 18-7786N3941KHawkins Allan S · Lizella, GABuilt 1967 · S/N 28-23816N3942NFlying Services Inc · Wilmington, DEBuilt 1968 · S/N 680007N3942QSullivan Donald Edward II · Edwards, ILBuilt 1971 · S/N 17260042N3944FHenley Johnny · Trenton, NCBuilt 1976 · S/N 28-7615432N3944KPeiker Laramie · Revillo, SDBuilt 1967 · S/N 28-23819N3944QFeauto Aviation Inc · Saint Cloud, FLBuilt 1971 · S/N 17260044N3944SAlpha Romeo LLC · Wray, COBuilt 1990 · S/N 728N3944ZTasch Kenneth O · Chilton, WIBuilt 1962 · S/N 18-7801N39456Lorber Robert M · East Brunswick, NJBuilt 1978 · S/N 28-7816660N3945FBrougnton Eric S · Catlettsburg, KYBuilt 1976 · S/N 28-7690463N3945KFisher Knute A · Kensington, CABuilt 1967 · S/N 28-23821
Back to AD 80-04-03 R2