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.

N7801WRegistered aircraftBuilt 1964 · S/N 28-1799N78027Cramlet Kirk T · Woodlake, CABuilt 1968 · S/N 17257467N7802VKruger Matthew J · San Francisco, CABuilt 1964 · S/N 2808N7803DFako John · Binghamton, NYS/N 22-5447N7803FKarlovich James W · Kingston, GABuilt 1957 · S/N 18-6259N7803GTomlin Jonathan S · Georgetown, OHS/N 17259503N7803VArtlip James · Wake Forest, NCS/N 2787N7803W3w Group Inc · Hot Springs, ARS/N 28-1807N7804GWells Adam · New Lexington, OHBuilt 1970 · S/N 17259504N7804NApaa Aviation Group LLC · Frisco, TXBuilt 1969 · S/N 28-5254N7804VVickers David Dewayne · Douglas, GABuilt 1964 · S/N 2788N78051Sipple Ronald W Jr · Gardner, KSS/N 2051N7805DMoretti Anthony · Deming, NMBuilt 1957 · S/N 22-5450N7805GArgabright John · Waterford, OHBuilt 1970 · S/N 17259505N7805NCorrigan Air Center · Hondo, TXBuilt 1968 · S/N 28-5256N78066Orlandi Properties LLC · Blairstown, NJBuilt 1968 · S/N 17257470N7806DHillegeist Tracy L · Beverly, KSS/N 22-5453N7806GAircraft Management Services Inc · Milton, FLBuilt 1970 · S/N 17259506N7806NTab Air Time LLC · Longmont, COBuilt 1968 · S/N 28-5257N7806PSpires Kenneth G · Seville, OHBuilt 1962 · S/N 24-3025N7806VMouriz Javier · Leesburg, FLBuilt 1964 · S/N 2790N78076Clinton Aeroclub · Clinton, IABuilt 1968 · S/N 17257472N78078International Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17257473N7807GLake Of The Woods Aviation LLC · Baudette, MNS/N 17259507N7807NBwh Leasing LLC · Lewes, DEBuilt 1968 · S/N 28-5258N7807VMad Dog Aviation LLC · Minot, NDBuilt 1964 · S/N 2791N78083Holcomb Garry · Point, TXBuilt 1946 · S/N 2083N78086Drake Ronald N · Helena, MTBuilt 1968 · S/N 17257475N7808VWalker Trenton A · Pittsburg, OKBuilt 1964 · S/N 2792N7808ZWiedeman Matthew A · Batesville, INBuilt 1966 · S/N 18-8485N78095Leuer James A · Encinitas, CABuilt 1968 · S/N 17257480N7809GHodge Aviation LLC · Monroe, LABuilt 1970 · S/N 17259509N7809NUninsured Justice Enterprises LLC · Joplin, MOBuilt 1968 · S/N 28-5260N7809WHand Lawrence E · Klamath Falls, ORBuilt 1964 · S/N 28-1816N780BGMaw Enterprises USA LLC · Hudson, FLBuilt 1980 · S/N 17274382N780DAFawley Dean · Newnan, GABuilt 1969 · S/N 28-5328N780DMTexas Barnstormers LLC · Rogers, TXBuilt 2004 · S/N 464-2004N780GAPrairie Planes LLC · Mitchell, SDBuilt 1978 · S/N GA7-0067N780GWSchreiber-Beck Cynthia K · Wahpeton, NDS/N 780N780UOhio University · Albany, OHBuilt 2005 · S/N 2842232N7810DPetro Jerry R · Williamsburg, VABuilt 1957 · S/N 22-5456N78110Fries Tyler · Kenai, AKBuilt 1946 · S/N 2110N78112Botnick Eric L · Luling, LABuilt 1968 · S/N 17257486N7811DGardner Thomas R · Summerville, SCBuilt 1957 · S/N 22-5457N7811VRivard Jayme · Monterey, CABuilt 1964 · S/N 2795N78123Rrr3 LLC · Midway, FLS/N 17257490N78124Barrow James L · Elizabethtown, KYBuilt 1968 · S/N 17257491N78126Orme Jason R · Red Oak, IABuilt 1968 · S/N 17257492N7812NSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28-5264N7812VStorrud Jerrel T · Corvallis, MTBuilt 1964 · S/N 2796
Back to AD 80-04-03 R2