OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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-25-02-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-25-02-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.

N93304Jodkin Jason · Confluence, PABuilt 1981 · S/N 15285464N9331LMalone Robert L · Cleveland, TNBuilt 1971 · S/N AA1A-0031N9332LPalone Carmen · Rices Landing, PAS/N AA1A-0032N93339Mcgee David · Monroe, LABuilt 1981 · S/N 15285470N93342Metro Technology Centers Aviation Career Campus · Oklahoma City, OKBuilt 1981 · S/N 15285471N9334LMedic Choppers LLC · Springdale, ARBuilt 1971 · S/N AA1A-0034N9335LGulfstream Aerospace Corp · Savannah, GABuilt 1971 · S/N AA1A-0035N93397Jet & Rotor Aviation LLC · Sacramento, CABuilt 1981 · S/N 15285479N9339LLumbra Valerie A · Lehigh Acres, FLBuilt 1971 · S/N AA1A-0039N933AZN933az LLC · Miami, FLBuilt 1980 · S/N 15284626N933BPMarr Steven K · Saint Charles, MOS/N 1585N933SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280526N93407Board Of Trustees DBA · Murphysboro, ILFirst renewal noticeBuilt 1981 · S/N 15285481N9341TWilliams Norman L · Ennis, TXBuilt 1978 · S/N 38-78A0048N9342LSeaton Robert D · Seguin, TXBuilt 1971 · S/N AA1A-0042N93434Silver Express Co DBA · Miami, FLBuilt 1982 · S/N 15285486N9343LC&L Aviation Ltd · Maysville, KYS/N AA1A-0043N93444Sullivan Wayne · Rockport, TXS/N 15285491N93454Marsh John E · Washington, DCBuilt 1982 · S/N 15285494N93468Bestway Transport LLC · Raymond, NES/N 15285496N93488Rawareo LLC · Warsaw, MOBuilt 1982 · S/N 15285501N9349LKearney Isabelle · Oklahoma City, OKBuilt 1971 · S/N AA1A-0049N9351LPiciullo Lenny R · Folsom, CAS/N AA1A-0051N9351TBenson Michael W · Julesburg, COBuilt 1978 · S/N 38-78A0063N93526Delta State University · Cleveland, MSBuilt 1982 · S/N 15285507N93529Richmor Aviation Inc · Hudson, NYBuilt 1982 · S/N 15285510N9354LElliott Brevyn · Marinette, WIS/N AA1A-0054N93550Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1982 · S/N 15285513N9356LCallaway Jonathan L · Van Alstyne, TXS/N AA1A-0170N93585Sipher William M · Baker, FLBuilt 1982 · S/N 15285521N9358TPitts Lynn Larry · Webb City, MOBuilt 1978 · S/N 38-78A0066N93590G & M Aircraft Inc · Wheat Ridge, COS/N 15285524N9360LSwanson Steven V · Saint Marys, GABuilt 1971 · S/N AA1A-0060N9361LWillis Daniel A · Clarksville, TNBuilt 1971 · S/N AA1A-0061N93621Sunrise Aviation · Ormond Beach, FLBuilt 1982 · S/N 15285527N9363LAmzallag Gerard Reuben · Oxnard, CABuilt 1971 · S/N AA1A-0063N9365LHartzog Christopher G · Greenwood, SCBuilt 1971 · S/N AA1A-0065N9367LHummel Mark I · Lakewood, WABuilt 1971 · S/N AA1A-0067N93689Board Of Trustees DBA · Murphysboro, ILBuilt 1982 · S/N 15285535N9369LNichols David M · Medford, ORBuilt 1971 · S/N AA1A-0069N9369TTarno Suzzan G · Avondale, AZBuilt 1978 · S/N 38-78A0074N93706Drake Charles R · Claremore, OKBuilt 1982 · S/N 15285539N9370LLawrence Guy · Bakersfield, CABuilt 1971 · S/N AA1A-0070N9372LBaugh Brett J · Jonesboro, ARBuilt 1971 · S/N AA1A-0172N93730Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1982 · S/N 15285543N9374LMcmanus Keith S · Carlisle, PABuilt 1971 · S/N AA1A-0074N9376LSchrick Robert B · Firth, NEBuilt 1971 · S/N AA1A-0076N9376TMosley Kenneth N · Westlake Village, CABuilt 1978 · S/N 38-78A0079N9377LLowry Joseph · Elizabethtown, ILBuilt 1971 · S/N AA1A-0077N9378LQuigley Patrick M · Slidell, LABuilt 1971 · S/N AA1A-0078
Back to AD 80-25-02 R2