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.

N5321ZAyers Mark T · Whitney, TXBuilt 1961 · S/N 22-9025N5322ZHall Rodney R · Portsmouth, VABuilt 1961 · S/N 22-9026N5325HAdams William Carter · Macon, GAS/N 16-130N5326HVan Zant Timothy L · Nenana, AKBuilt 1949 · S/N 16-131N5327HNass Michael F · Clinton, IABuilt 1949 · S/N 16-132N5329ZCline Wade J · Reno, NVBuilt 1962 · S/N 22-9034N532RSZacherl Randall L · Indiana, PABuilt 1980 · S/N 15284322N53311Barksdale Air Racing LLC · Conroe, TXS/N 1143-76N5331ZDaye Jeffrey E · Salisbury, NCBuilt 1962 · S/N 22-9038N5332ZGulley Mark E · Guntersville, ALBuilt 1961 · S/N 22-9041N5333HMcchristian Jerome M · Granbury, TXS/N 16-139N5333ZRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1961 · S/N 22-9042N5334ZUeeck Robert D · Minnetonka, MNS/N 22-9044N5335PFlying Vikings Inc · Hayward, CABuilt 1981 · S/N 15284919N5335ZGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 22-9045N5337HOder Kenneth L · Taylorsville, KYBuilt 1949 · S/N 16-143N5337LFather Son Ing LLC · Wilmington, DEBuilt 1980 · S/N 15284296N5337PHanson David J · Elgin, TXBuilt 1981 · S/N 15284920N5337ZBrown Estates Aviation LLC · Fresno, CABuilt 1961 · S/N 22-9047N53380Haltom Gary D · Alva, OKS/N 15283540N5339BFiebig Howard J · Sebewaing, MIBuilt 1979 · S/N 15283841N5340HHarmon Michael N · Ankeny, IABuilt 1949 · S/N 16-144N5342PSp Airparts LLC · Moscow, IDBuilt 1981 · S/N 15284921N5343HDawson Guy · Lake Clear, NYBuilt 1949 · S/N 16-149N5343ZGolden Age Aeroworks LLC · Lone Rock, WIBuilt 1962 · S/N 22-9059N5344BJohn Annin LLC · Fenton, MOBuilt 1979 · S/N 15283843N5344MPinger Kevin R · Palo Alto, CABuilt 1980 · S/N 15284548N5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LABuilt 1980 · S/N 15284549N5348BBowers Curt E · Jennings, LABuilt 1979 · S/N 15283844N5348ZDavis Robert D · Shongaloo, LABuilt 1961 · S/N 22-9068N5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1980 · S/N 15284553N5350PChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15284924N5350ZAgalotis Paul E · San Martin, CABuilt 1961 · S/N 22-9071N5351LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284298N5351PPointair Aviation Inc · Port Jeff Sta, NYS/N 15284925N5351ZGostola Thomas · Fairmount, INBuilt 1961 · S/N 22-9072N5352ZMcdougall Michael D · Caldwell, IDBuilt 1961 · S/N 22-9075N5353HDe Nunzio Arnold J · Ballard, CABuilt 1979 · S/N 15284090N5354ZManson Timothy C · New Gloucester, MEBuilt 1961 · S/N 22-9077N5355PPittsburgh Pilot Training LLC · Bethel Park, PABuilt 1981 · S/N 15284926N5355QGorge Winds Aviation Inc · Fairview, ORBuilt 1981 · S/N 15285104N5355ZWatts Carrie L · Hazen, NVBuilt 1961 · S/N 22-9078N5356HMurphey Stephen B · Lynchburg, SCBuilt 1949 · S/N 16-162N5357HRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15284092N5357PSunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15284927N5358HDaniels Scott M · Litchfield, MEBuilt 1949 · S/N 16-165N5359ZSale Reported · Crozet, VASale reportedS/N 22-9085N535FLJestes Monte G · Stillwater, OKBuilt 2005 · S/N F-3747N535TCNichols Craig J · Andover, MNBuilt 1947 · S/N 12-3976N5360HEastern Stearman Inc Trustee · Leesburg, VABuilt 1949 · S/N 16-167
Back to AD 80-25-02 R2