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.

N5491PKs Aviation Inc · Atwater, CABuilt 1981 · S/N 15284958N5493ZMcnabb James A Trustee · Grove, OKBuilt 1962 · S/N 22-9278N5494PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15284959N5494ZLanham William B · Mineral Wells, TXBuilt 1962 · S/N 22-9279N5495QNovember Sierra Aviation LLC · Oneill, NES/N 15285113N5495ZHayes Robert L · Chesapeake, VABuilt 1962 · S/N 22-9281N5497ZShira Daniel C · Homedale, IDBuilt 1962 · S/N 22-9283N5498ZCunningham Florence Jean · Spokane Valley, WAS/N 22-9284N5499QCronce Charles Scott · Pacifica, CABuilt 1981 · S/N 15285114N549DMCallaghan Jerry R · El Paso, TXBuilt 1961 · S/N 22-8500N54JTEhlers Louis H · Sedgwick, KSS/N 20AN54MFFaulkner Max R · Bourbon, INBuilt 1997 · S/N 01N5500ZPfc Aviation Repair Inc · Wallingford, CTS/N 22-9286N5502CWebb Brad · Ekron, KYBuilt 1978 · S/N 1259-78N5502U90 Degree Crosswind LLC · Arcadia, FLBuilt 1978 · S/N 1260-78N5503VPurstell Kevin D · Burnt Hills, NYBuilt 1978 · S/N 1262-78N5504NWighs Terry L · Fairbanks, AKBuilt 1978 · S/N 1264-78N5505NMargolies Lars · Goldens Bridge, NYBuilt 1978 · S/N 1266-78N5506CBattle Creek Powersports LLC · Jasper, TNBuilt 1978 · S/N 1267-78N5506HWoods George M · Anchorage, AKS/N 1240-78N55072Lorenzo John V · Tulare, CABuilt 1978 · S/N 1269-78N5507HAdair Caden S · Anchorage, AKBuilt 1978 · S/N 1273-78N5508MLindvig Thomas H · Williston, NDBuilt 1978 · S/N 1272-78N5513LCandice Alarned Enterprises Inc · Long Beach, CABuilt 1980 · S/N 15284326N5514LFlight School Of Gwinnett Inc · Lawrenceville, GAS/N 15284327N5514ZWilkinson Bruce O · Williamsburg, VABuilt 1962 · S/N 22-9301N5515QLassiter Bobby L · Newport, ARBuilt 1981 · S/N 15285115N5515ZLandrum Kelly T · Halifax, VABuilt 1962 · S/N 22-9302N5516LBarnes Richard A · Federal Way, WABuilt 1980 · S/N 15284329N5517KCarter Brantley F · Timmonsville, SCBuilt 1978 · S/N 1253-78N5517PVoorhees Kenneth J · Aiea, HIBuilt 1981 · S/N 15284963N5519HOstendorff Eric C · Torrance, CAFirst renewal noticeBuilt 1979 · S/N 15284109N551EZAsis Robert O · Huntington Beach, CAS/N 1551N5520LBlue Feathers Corp · Newark, DEBuilt 1980 · S/N 15284331N5521ZTessenear James A · Hopewell, VABuilt 1962 · S/N 22-9309N5522ZWolfe Robert N · Rogers, TXBuilt 1962 · S/N 22-9310N5525HStewarts Aircraft Service Inc · Waynesville, OHBuilt 1979 · S/N 15284114N5528ZSmith Ryan M · Midland, TXS/N 22-9317N5529KFloren Donald D · Royal City, WABuilt 1978 · S/N 1255-78N5530ZReeves Todd J · Mosier, ORS/N 22-9319N5531HXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15284118N5531MPeterson Jay O · Las Vegas, NVBuilt 1980 · S/N 15284606N5531ZDarr Henry S · Drummond, MTBuilt 1962 · S/N 22-9321N5533BKnudson Eddie T · Arvada, WYS/N 15283896N5535ZPayne Dustin J · Weirsdale, FLS/N 22-9325N5537HLine Michael · University Park, MDBuilt 1979 · S/N 15284121N5538ZBradburn William P · Pearl River, LAS/N 22-9328N553BDBooker Daniel R · Newaygo, MIBuilt 2020 · S/N 75-10566N553HBrantley Hugh L · Hazlehurst, GABuilt 1971 · S/N AA1A-0295N553SWillhoite Steven B · Louisburg, KSBuilt 1998 · S/N 1998
Back to AD 80-25-02 R2