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.

N9597BCanada Gary Jr · Coy, ARS/N 1095N9597JWingswat LLC · Placentia, CABuilt 1966 · S/N 28-3743N9597LRowe Richard D · Waterloo, INBuilt 1974 · S/N AA5-0597N9597VSkelton Jeffrey · Sioux Falls, SDBuilt 1974 · S/N 17264399N9598BIpsen Michael · Kenosha, WIBuilt 1981 · S/N 172RG0909N9598DDurden William L · Tallahassee, FLBuilt 1958 · S/N 22-6506N9598JMardis Andrew · Pelzer, SCBuilt 1966 · S/N 28-3744N9598UJackler Leon J · Silver Spring, MDBuilt 1976 · S/N AA5A-0098N9598ZDel Valle Enterprises Inc · Sandpoint, IDBuilt 1989 · S/N 1102N9599JOrban Kenneth D · Tellico Plains, TNBuilt 1966 · S/N 28-3745N9599KRed Wing Soaring Association · Osceola, WIBuilt 1989 · S/N 1111N9599WNelson Scott G · Lakota, NDS/N 28-23050N9599ZBorn John G · Jupiter, FLBuilt 1989 · S/N 1117N959AGGrant Altin C · Tahlequah, OKBuilt 1973 · S/N 17701952N959DBSigma Pharmaceuticals LLC · Monticello, IABuilt 1999 · S/N 14095CN959ERs Specialties LLC · Anchorage, AKBuilt 1955 · S/N 18-4021N959HCNorthwest Wings LLC · Hillsboro, ORBuilt 1973 · S/N 17262361N959PDMilligan Thomas A · Dana, INBuilt 2002 · S/N 1336-2002N959RDDoering Ray A · Devils Tower, WYBuilt 1979 · S/N 18-7909159N959RMLargent Richard B · Southport, NCBuilt 1970 · S/N 17259113N959TELawless John M Jr · Tucson, AZBuilt 2004 · S/N 10238N95AACoolidge Marvin L · Newberg, ORBuilt 1959 · S/N TD-256N95AHBrown Hunter · Sulphur Rock, ARBuilt 1978 · S/N 18-7809152N95BRChickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 28-25841N95CHJones Cecil W · Fort Walton Beach, FLBuilt 2020 · S/N 80956N95CJSimmons Marshall · San Antonio, TXBuilt 1960 · S/N TD-334N95CPGates Thomas S · Moyock, NCBuilt 1976 · S/N 17265896N95DLOwen Jayson S · Tampa, FLBuilt 1960 · S/N TD-418N95EGNelson Gregory E · Austin, TXS/N 636-320-381FBN95GWSkypirate Aviation LLC · Staunton, VABuilt 1995 · S/N 21373N95HDGreffenius Brian J · Covington, LABuilt 1995 · S/N 1255N95JALane Christopher C · Dallas, TXBuilt 1979 · S/N 172RG0015N95JPKeller Justin Allen · Youngstown, FLBuilt 1973 · S/N 28-7305429N95MMManley Marvin W · Camp Verde, AZBuilt 1998 · S/N 60035N95QLoftis Philip D · Buckhannon, WVBuilt 1975 · S/N 28-7515408N95RSpence Justin A · Memphis, TNFirst renewal noticeBuilt 1967 · S/N OAS-1N95RWColberg Stefan D · North Bend, ORS/N I-AN95SHReady Aim Flyer LLC · New Castle, DEBuilt 1957 · S/N TD-21N95WPPercival Wilhelm F · Las Vegas, NVBuilt 1987 · S/N 1995LN95YWhite Tavis · Huntsville, ALBuilt 1964 · S/N TD-604N96009Loera Arnold · Dillingham, AKBuilt 1990 · S/N 1124N9600JCox Grant L · Moses Lake, WABuilt 1989 · S/N 1118N9600SHargrove Tom R · Coffeyville, KSBuilt 1966 · S/N 2N9600UUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7816505N9601DRiffle David T · Woodinville, WABuilt 1958 · S/N 22-6510N9601JGevers Robert L · Lafayette, INBuilt 1966 · S/N 28-3747N9601QSteel Aviation Inc · Walnut Cove, NCBuilt 1975 · S/N 17265686N9602BLaguna Verde Leasing Inc · Wilmington, DES/N 172RG0912N9602SKrepfl Martin J · Colorado Springs, COBuilt 1965 · S/N 50N96033Sullivan Leo W · O Fallon, ILBuilt 1990 · S/N 1127
Back to AD 80-04-03 R2