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.

N5055ZStevens Mark F · Ocean Springs, MSBuilt 1961 · S/N 22-8679N5056TGator Flight LLC · Saint Cloud, FLBuilt 1979 · S/N 1319-79N5058KWinemiller Stevie D · Swifton, ARBuilt 1979 · S/N 1320-79N5058NCarbone Cabana Boys LLC · Mercer Island, WABuilt 1979 · S/N 1321-79N5059GLumland Properties LLC · Winchester, VABuilt 1980 · S/N 1343-80N5059NSchultze Joseph Dale · Mound, MNBuilt 1979 · S/N 1322-79N5059ZWarren Kenneth N · Anamosa, IABuilt 1961 · S/N 22-8684N505SHHitchens Steven L · Newark, OHBuilt 1972 · S/N 882-72N5060NNarveson Bryce J · Nerstrand, MNBuilt 1979 · S/N 1323-79N5060XFour Guys Flying LLC · Tunica, MSBuilt 1968 · S/N 648N5062GMore Right Rudder LLC · Menlo Park, CABuilt 1979 · S/N 1325-79N5062JDomack Christopher S · Toccoa, GABuilt 1980 · S/N 1347-80N5062ZTerpstra Gregory K Trustee · Potosi, MOBuilt 1961 · S/N 22-8687N5063ZMuehlberg Timothy M · Tuttle, OKBuilt 1961 · S/N 22-8688N5064KShin Harry K Jr · Castro Valley, CABuilt 1979 · S/N 1335-80N5064ZGregory Trace D · Springfield, MOBuilt 1961 · S/N 22-8692N5065KHahn Troy J · Troy, OHS/N 1329-80N5065NWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 1330-80N5066GRuggles Arthur E · Andersonville, TNS/N 1331-80N50674Garcia Joan M · Orlando, FLBuilt 1941 · S/N 5-1383N5067CMutter William D · Chelan, WABuilt 1979 · S/N 1333-80N5068KMcclung Matthew T · Avon, INBuilt 1979 · S/N 1338-80N5068UCaywood Beauregard Janice E · Hollis, NHBuilt 1979 · S/N 1339-80N5068YFarnham Aviation Services LLC · Ames, IABuilt 1979 · S/N 1340-80N5069FMunns Dana K · Diamondhead, MSBuilt 1980 · S/N 1341-80N506DKolstad David L · Northridge, CABuilt 1982 · S/N 2027N506DEAero Fliers LLC · Kalispell, MTBuilt 1977 · S/N 15279717N5070ZMoser Gary A · Van Wert, OHBuilt 1961 · S/N 22-8698N5072ZMunning Doris E Trustee · Sellersburg, INBuilt 1961 · S/N 22-8701N5075XOpjorden Chris T · Litchfield, MNS/N 139N5076ZBottoms Michael L · Danbury, NCS/N 22-8707N5078ZPierce Justin P · Conifer, COS/N 22-8709N5079ZJohnson Sappa Farms LLC · Stamford, NEBuilt 1961 · S/N 22-8710N5080ZBrazil Joshua B · Omaha, NEBuilt 1961 · S/N 22-8711N5081ZTech Mobile LLC · New Windsor, MDBuilt 1961 · S/N 22-8712N5082ZHuddleston Anthony A · Knoxville, TNBuilt 1961 · S/N 22-8713N5083ZMorell Patrick J · Byron Center, MIBuilt 1961 · S/N 22-8714N5085BAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 15283739N5086ZRichards Curtis A · Troy, MOBuilt 1961 · S/N 22-8718N5087LGreen Airport Development Corp · Kemah, TXBuilt 1980 · S/N 15284253N5088LRichmor Aviation Inc · Hudson, NYBuilt 1980 · S/N 15284254N5088XAmerican Aviation II LLC · Peyton, COS/N 659N5088ZDavis Scott A · Bingham, NEBuilt 1961 · S/N 22-8722N5089PBroburg Gregory William · Minneapolis, MNBuilt 1981 · S/N 15284873N5089XYarger Pete A · Hamilton, INBuilt 1969 · S/N 654N508TBlackburn D S · Yukon, OKBuilt 1968 · S/N 611N5090QTakai Hiroyasu · San Jose, CABuilt 1981 · S/N 15285071N5090XOwen Suzanne L · Eagle Point, ORBuilt 1969 · S/N 655N5091XMorois Jake D · Green Bay, WIBuilt 1969 · S/N 656N5092XCurcio Joseph A Jr · Granite Bay, CAS/N 657
Back to AD 80-25-02 R2