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.

N925DGNwi Drones LLC · Chesterton, INBuilt 1960 · S/N 24-1870N925ERCrosswell Joe D · Springtown, TXS/N 385-72N925HEWatson James C · Boerne, TXBuilt 1989 · S/N 491N925JLLudwig Jerry F · West Ossipee, NHBuilt 2004 · S/N 22439N925MKOates Douglas E · Elgin, SCBuilt 1966 · S/N 28-3325N925NEriksson Kurt R · Soldotna, AKBuilt 1978 · S/N 18-7909007N925PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843288N925RSHall Jeffrey I · Broken Arrow, OKBuilt 2004 · S/N 1111N925TARutan Aircraft Flying Experience · Waller, TXBuilt 1992 · S/N S 60N925TEHarris David A · Cleves, OHBuilt 2001 · S/N 10204N9260SChristiansen Dee W · Kerrville, TXBuilt 1975 · S/N MB-781N9260TCanoace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8616033N9260VBravo Aero LLC · Concord, NCBuilt 1969 · S/N 690069N92617Stahl Raifen · Anchorage, AKBuilt 1973 · S/N 17261594N9261DBales Carson E · Wasilla, AKBuilt 1958 · S/N 18-6555N9261HSchrom Frederick A · Carlisle, PABuilt 1975 · S/N 17266054N9261JLear Steven J · Rockville, INBuilt 1966 · S/N 28-3337N9261MPickett Trina M · Riverside, CABuilt 1966 · S/N 3455N9261PUdell Brian · Queen Creek, AZS/N 18-8901N9262HAero Maintenance Inc · Vancouver, WAS/N 17266055N9263HPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1975 · S/N 17266056N9263JHarrod Andrew A Jr · El Segundo, CABuilt 1966 · S/N 28-3339N9263LSkyhawk Flying Club Inc · Franklin Grove, ILBuilt 1996 · S/N 2843023N9263VOrton Leon J · Nibley, UTBuilt 1969 · S/N 690070N9264DCenter Charles C · Wasilla, AKBuilt 1958 · S/N 18-6562N9264FWilson Jonathan · Natchez, MSS/N M-476N9265DGagnon Matthew I · Fairbanks, AKS/N 18-6563N9265HCleveland Douglas P · Live Oak, FLBuilt 1975 · S/N 17266057N9265JStuvland Christopher · Pendleton, ORBuilt 1966 · S/N 28-3341N9265PWard Benny · Raleigh, NCS/N 2843024N9266JTaccone Glenn R · Henderson, NVBuilt 1966 · S/N 28-3343N9267JLarson Christopher J · Saint Maries, IDBuilt 1966 · S/N 28-3344N9268JRegistered aircraftBuilt 1966 · S/N 28-3345N9268VNelson Edward C · Manorville, NYBuilt 1969 · S/N 690072N9269GLauterbach Dean C · Newton, IABuilt 1996 · S/N 2843021N9269HLargen Gregory K · Benton, KSBuilt 1975 · S/N 17266059N9269JHelm Daniel E · Portland, ORBuilt 1966 · S/N 28-3346N9269QAero-Tech Services Inc · Lititz, PABuilt 1996 · S/N 2843031N926BWTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1974 · S/N 770-74N926CKFly By Numbers LLC · Tallahassee, FLBuilt 1976 · S/N 28-7690327N926DGPerkins James W · Georgetown, TXBuilt 2000 · S/N 20473N926DKSuthar Jay P · Danville, VABuilt 2002 · S/N 22867N926EZEcho Zulu LLC · Middletown, DES/N HSLE 2-95N926JPJl Aviation LLC · Crestwood, KYBuilt 2004 · S/N 490-2004N926MKToothman John C · Fairmont, WVBuilt 1971 · S/N 28-7125138N926MNPtw Consulting LLC · Atlanta, GABuilt 1971 · S/N 17260325N926RUPottratz Dwane L · Beaverton, ORBuilt 1998 · S/N 23327N926TEAnderson & Associates Inc · Little Rock, ARBuilt 2002 · S/N 10205N92704Gull Wing Flight LLC · Pt Pleas Bch, NJBuilt 1973 · S/N 17261605N9270DDowns Dennis D · Sterling, AKS/N 18-6569
Back to AD 80-04-03 R2