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.

N2515YNationwide Aviation LLC · Weatherford, TXBuilt 1985 · S/N 28-8516074N2515ZMarker Richard A · Healdsburg, CABuilt 1977 · S/N 347-77N2516PNidle Jeffery C · Leasburg, NCBuilt 1955 · S/N 22-2878N2516QKris Noone Air LLC · Wilmington, DES/N 889N25179Strite Kenneth J · Xenia, OHBuilt 1976 · S/N 531N2517RWaterfront Developers Inc · Hickory, NCBuilt 1969 · S/N 28-5640N2518ARegistration Pending · Wasilla, AKRegistration pendingBuilt 1953 · S/N 18-2148N2518GVintage Aviation Inc · Garden City, NYBuilt 1967 · S/N 166N2518UMitchell Daniel S · Shavano Park, TXBuilt 1979 · S/N 28-8016027N25190Wiley Calvin B · Summer Shade, KYBuilt 1940 · S/N 1011N2519PDayton Dean W · Marysville, OHBuilt 1955 · S/N 22-2881N2519ZWatson Bobby M · Hoxie, ARBuilt 1977 · S/N 993-77N251DMBandt Johnathan Paul · South Milwaukee, WIBuilt 2000 · S/N 1284-99N251HPKoch & Koch Inc · Grass Valley, CABuilt 1982 · S/N 172RG1124N251JBVan Horne Robert E · Centralia, ILBuilt 1965 · S/N 21N251MANorris Suzanne W · Howe, IDBuilt 2003 · S/N 1346-2003N251NDKasowski Flint · Buffalo, NDBuilt 1998 · S/N 2842042N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249N251RBNewton Roger N Jr · Marrero, LABuilt 1984 · S/N 408N251RXPlane Therapy LLC · Hudson, FLBuilt 1978 · S/N AA5A0545N251WCThyssen Patrick L · Conroe, TXBuilt 2000 · S/N 424-2000N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641N2521SSieberts Soren K · Anchorage, AKBuilt 1979 · S/N 18-7909152N2521UN2521u LLC · Danbury, CTBuilt 1979 · S/N 28-8016029N2523AChadwick Harold T · Ottsville, PABuilt 1952 · S/N 22-829N2523PHarris Jason C A · Unalakleet, AKS/N 22-2885N2523UPro Renovations Savannah Ltd Co · Savannah, GABuilt 1979 · S/N 28-8016030N2524MDd Leasing LLC · Aberdeen, IDBuilt 1946 · S/N 12-910N2524UAir Warriors LLC · Opelika, ALBuilt 1979 · S/N 28-8016031N2525Davis Bill M · Kent, WABuilt 1976 · S/N 28-7790180N25259Miller Eric J · Mendocino, CAS/N 982N2525YWilde Stephen · Elverta, CABuilt 1985 · S/N 28-8516075N2526MTulin Donald J · Anchorage, AKS/N 12-1017N2526WCulling Thomas E · Venice, FLBuilt 2000 · S/N 25419N25278Winterton Phillip C · Tucson, AZS/N 1001N2527DSidders Michael E · Big Lake, AKS/N 20679N2527PSprenger Michael D · Juneau, AKBuilt 1955 · S/N 22-2890N2527UDeljanovan Trucking LLC · Roaring Branch, PABuilt 1979 · S/N 28-8090050N2528Morrison Garrett B · Lodi, CABuilt 2016 · S/N 7149N2528SScola Kevin M · Marshfield, MABuilt 1979 · S/N 18-7909153N2528UPensacola Navy Flying Club · Pensacola, FLBuilt 1979 · S/N 28-8090051N252CERegistration Pending · Springtown, TXRegistration pendingBuilt 2003 · S/N 4166N252DZBernardo Mark · Middleton, MABuilt 1978 · S/N AA5B0736N252ECClear Sky Ag Services LLC · Arapahoe, COBuilt 1969 · S/N 28-25277N252ERBeaurayne Holdings LLC · Prairieville, LABuilt 1978 · S/N 17271635N252MDFreeman Edward B · Killeen, TXBuilt 1993 · S/N 4001N252RAReynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17269911N252SBRoberts Christopher E · Anchorage, AKS/N 17270764N25315Ifr Inc · San Juan, PRS/N 1003N2531FFishwick Steve K · Hamilton, OHBuilt 1966 · S/N 22
Back to AD 80-04-03 R2