AD 80-25-07 R1

Registered aircraft · 25,369

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-07-R1')
    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-07-R1')
  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.

N8334LAirspeed Marketing Bravo LLC · Phoenix, AZBuilt 1968 · S/N 17256534N8334VRegistration Pending · Milton, FLRegistration pendingBuilt 1966 · S/N 482N8335VLisoski Derek L · Clark Fork, IDBuilt 1966 · S/N 474N8337VWydronek Joseph A · Tucson, AZBuilt 1966 · S/N 422N8338LTreimer Aviation LLC · Davenport, IABuilt 1968 · S/N 17256538N8338VGustafson Cody A · Corvallis, ORBuilt 1966 · S/N 401N8339LRohrbaugh David J · Oakland, MDBuilt 1968 · S/N 17256539N833CBDehaan David J · San Diego, CAS/N 17267867N833RTNash LLC · Carbondale, ILBuilt 1982 · S/N P21000809N833TWDesert Wind Wings LLC · Mesa, AZS/N 172RG0193N8340LHess Garrett J · Fullerton, CABuilt 1968 · S/N 17256540N8342VPrecision Aerial Ag LLC · Seneca, KSS/N 232N8344LHeir Borne Flying Club Inc · Minot, NDBuilt 1968 · S/N 17256544N8346LJones Mark B · Angleton, TXBuilt 1968 · S/N 17256546N8346VLovley Linda C · Jordan, MNBuilt 1966 · S/N 127N8347LSchye Ted E · Billings, MTBuilt 1968 · S/N 17256547N8348LPrice William B · Lamar, SCBuilt 1968 · S/N 17256548N8349EArment C Randall · Valentine, NEBuilt 1979 · S/N 17272191N834GTIlmberger Stephen R · Sisters, ORBuilt 1981 · S/N 15285111N8350VMertz Rachel A · New Ulm, MNFirst renewal noticeBuilt 1966 · S/N 85N8351LPlane Junkies LLC · Dover, DEBuilt 1968 · S/N 17256551N8352LFielding David · Scarborough, MES/N 17256552N8353VN8353v LLC · Monroe, LAS/N 294N8354LEast Texas Imperial Petroleum LLC · Flint, TXBuilt 1968 · S/N 17256554N8356ESky West Aviation Inc Trustee · Albuquerque, NMS/N 17272192N8356VGroh David A · Mason, MIBuilt 1966 · S/N 478N8357VHaas Daniel S · Camarillo, CABuilt 1966 · S/N 136N8358LOc Flight Lessons LLC · Costa Mesa, CABuilt 1968 · S/N 17256558N8359LBay Lux Ventures LLC · Tampa, FLS/N 17256559N8359VCressman Scott M · Mount Pleasant, TXBuilt 1966 · S/N 412N8361LMolid Robert J · Dubuque, IABuilt 1968 · S/N 17256561N8365LHarbour Aviation LLC · Weatherford, TXBuilt 1968 · S/N 17256565N8365VJarvis Stormy A · Anchorage, AKBuilt 1966 · S/N 66N8366LCurwin Randy S · Villa Rica, GABuilt 1968 · S/N 17256566N8367LRay Allens Electronics Inc · Butler, GABuilt 1968 · S/N 17256567N8368LMeltzair LLC · Fryeburg, MEBuilt 1968 · S/N 17256568N8368VRare Air LLC · Forsyth, MTBuilt 1966 · S/N 49N8369LInternational Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17256569N8369VCentral Virginia Aviation Inc · N Dinwiddie, VAS/N 468N836DBR&L Sales LLC · North Vernon, INBuilt 1969 · S/N 17701366N8371VPrairie Thermals LLC · Brookings, SDBuilt 1966 · S/N 82N8372LRed Sky Aviation LLC · Livermore, CABuilt 1968 · S/N 17256572N8372VVarwig Korrey L · Peoria, ILBuilt 1966 · S/N 432N8373LFaulkner Jeannine P · Bethel, AKFirst renewal noticeBuilt 1968 · S/N 17256573N8373VSeidler Marlyn L · Underwood, NDBuilt 1966 · S/N 121N8374LGeneral Aviation LLC · Henderson, NVBuilt 1968 · S/N 17256574N8374VDexter Fred M · Live Oak, FLS/N 449N8375VCarll Elizabeth M · Chicago, ILBuilt 1966 · S/N 505N8376VKirkeby Dean A · Clark, SDBuilt 1966 · S/N 80N8377VWeber William A · Brodhead, WIBuilt 1966 · S/N 280
Back to AD 80-25-07 R1